Skip to main content

A-Z sort order for numbers

  • May 13, 2020
  • 1 reply
  • 0 views

I have a field of dates that are in text form (for purposes of a Zapier automation - Zapier is unable to put entries into Airtable “Date/Time” fields. If I am wrong, please let me know). It is in MM/DD/YYYY format. When we sort the field by A-Z, the MM/DD section sorts properly, but when it gets to YYYY, it is sorting “2020” before “2019”. Why is that, and is there any way to fix this? Thanks.

1 reply

Forum|alt.badge.img+20
  • Inspiring
  • 375 replies
  • May 13, 2020

Hi @Karen_Shim,

You can definitely write a date into Airtable from a Zapier integration. You may be running into an issue if you’re pulling the date from a source where it’s formatted differently than how you have your Airtable date field configured. I’d double check that both the incoming data and the date field have the same configuration.


Reply