Sort by date chronologically

[Shannon_Z]

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!

[Noor]

Shannon_Z:

yyyy-mm-dd

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]

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

[kuovonne · Accepted solution]

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.

[Shannon_Z]

ah i found it! thanks!