Apr 07, 2016 03:24 AM
I see that I can sort by 1 -> 9
or A -> Z
, but is there a way to sort chronologically?
Solved! Go to Solution.
Sep 24, 2018 04:34 PM
That’s not what I get when I sort by date at all.
When I sort by a “Date” field by 1 -> 9
:
I get appropriate sorting by Year, Month, Day:
Jan 22, 2019 03:36 PM
Yes, you can sort by date. This was killing me, too. Set your date format to:
ISO (2019-01-22), that’ll make the sort work properly. Then you can autonumber if you need to enforce a sort by item added.
Mar 07, 2019 09:09 PM
But it doesn’t work the same for pivot tables and charts
Mar 01, 2020 11:46 AM
I’m trying to sort by date as pictured below and it’s clearly not working. What am I doing wrong? The numbers don’t change whether I do 1-9 or 9-1…
Mar 04, 2020 10:49 AM
Hi Katelynn – sorry if we don’t make this clearer.
On grouped views, the Sort menu affects the order of records within a grouping, and not the order of the groupings themselves. You can change the order of the groupings from the Group menu (in this case, the grouped field is a linked record field, and in turn cannot be sorted by date).
I might recommend grouping first by the Due date field, and then by the Customer field. Or you can just as well sort by the Due date field and then by the Customer field.
Hope this helps a bit.
Mar 04, 2020 11:05 AM
I removed the grouping, then sorted by in home dates and then re grouped by customer which gave me the result I was looking for.
Hopefully this continues to work as I add to the table!
Thanks for your assistance!