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!
Best answer by kuovonne
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.
+4Hi @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
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
ah that’s the problem, the field customization is “link to xyz table”, so i cannot edit the date format
+29Are 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.
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.