View not sorting dates at all, on a table view
Think We tried that, cheers Lynn
@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;
Tried sorting dates from three date fields
just using table sort
Dates all over the place!!!
Capture27|281x500
Can you give us a screenshot from this table view’s details?
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.
See also:
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |