Is there a way to sort chronologically?

[erlend_sh]

I see that I can sort by 1 -> 9 or A -> Z, but is there a way to sort chronologically?

[Jeremy_Oglesby]

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:

[Aaron_Linsdau]

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.

[RommelParas]

But it doesn’t work the same for pivot tables and charts

[Katelynn_Straw1]

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…

[Pete · Accepted solution]

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.

[Katelynn_Straw1]

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!