Help

Setting Account Default Dates

Topic Labels: Dates & Timezones
658 0
cancel
Showing results for 
Search instead for 
Did you mean: 
oreocereus
8 - Airtable Astronomer
8 - Airtable Astronomer

I seem to remember reading somewhere that Airtable takes the local date settings from your computer for it's default formats. I.e. here in New Zealand, we represent date "DD/MM/YY," where as "MM/DD/YY" seems to be thing in America. Most of the time, Airtable uses the DD/MM/YY format.

However, I occasionally run into an issue where writing formulas with dates (e.g. "if this happens before 01/10/2023, then this"). It seems in formula (and I guess perhaps script) functions of airtable, it only interprets american formats. Is there a way to manually override this as an account setting, so I don't have to figure out why my new formula isn't working each time? (It happens infrequently enough that it's usually a ten minute problem to figure out - and isn't very friendly to my colleague who uses airtable far less often but might need to play with a formula I've made).

0 Replies 0