View not sorting dates at all

Greener_Power1 · 12-17-2020 03:15 AM

View not sorting dates at all, on a table view

Lynn

Greener_Power1

Think We tried that, cheers Lynn

LeventK

@Greener_Power1
You might have tried what @Lynn had offered but I’m afraid you may not have read it carefully. Would you mind giving some major details or should we bring out our palantir to the table and ask from it? Thank you.

For example;

What have you tried?
Are you using a VC with expression to sort the table data or just sorting around a column?
By what means do you think that the table data is not sorted?
Any screenshots showing the issue?

Greener_Power1

Tried sorting dates from three date fields
just using table sort
Dates all over the place!!!
Capture27|281x500

LeventK

Can you give us a screenshot from this table view’s details?

Steve

Are you trying to be difficult? You’re definitely achieving it.

The column you’re grouping on is not a Date value, it’s a Text value:

In fact, they are sorted correctly, as Text values in ascending alphabetical order.

To get a listing grouped by month in ascending date order, you’ll have to group by a column of type Date, but you won’t be able to display only the month and year–you’ll have to display the entire date. Consider adding a column with an App formula of (EOMONTH([Paid Date], -1) + 1) to contain the date of the first day of the month, then grouping by that.