Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Setting Account Default Dates

Topic Labels: Dates & Timezones
826 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