I’m running into an issue with a calculated field. I have the following formula:
“Add Contract Date”,
My issue is that, rather than sorting the date chronologically, Airtable is sorting it alphabetically. This happens with both MM-YYYY and MMM-YYYY formats (the only two I can use for this application).
For instance, with MM-YYYY, my sort looks like this:
Similarly for MMM-YYYY (April, then August, etc)
How do I fix this? Do I need to wrap my calculation somehow?