Help

Sort by date chronologically

Solved
Jump to Solution
2401 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Shannon_Z
5 - Automation Enthusiast
5 - Automation Enthusiast

hi!

i have a field that is linked to another table, and that field is a date.

I’m trying to sort chronologically, but from what i see, it can only be sorted alphabetically.

is there a way to change the settings of the date to yyyy-mm-dd in numbers instead of mm-yyyy now so i can sort chronologically? or any way to do that?

thanks!

Screenshot 2022-04-20 at 2.03.50 PM

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Are you using the Batch Update app? That always does an alphabetical sort. You can change the format of the primary field in the linked table to ISO format.

See Solution in Thread

4 Replies 4
Noor
6 - Interface Innovator
6 - Interface Innovator

Hi @Shannon_Z
welcome to Airtable community

Yes it’s possible to solve
you can change the date format from customized field. If you go do field customization for the table from where you picking this date then you will see the “date format” options then from the options choose “ISO” format…then it will solve your problem

Thanks
Noor

Shannon_Z
5 - Automation Enthusiast
5 - Automation Enthusiast

ah that’s the problem, the field customization is “link to xyz table”, so i cannot edit the date format

kuovonne
18 - Pluto
18 - Pluto

Are you using the Batch Update app? That always does an alphabetical sort. You can change the format of the primary field in the linked table to ISO format.

ah i found it! thanks!