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 |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |