Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Supported locale modifiers for SET_LOCALE

Topic Labels: Formulas
319 2
cancel
Showing results for 
Search instead for 
Did you mean: 

my locale format was DD/MM/YYYY
i try make it work but it looks like this!
Screenshot (3)|652x222
i really wanna know why keep telling March NOT August

2 Replies 2

What types of fields are those? If you’re using formulas, what are the formulas that you’re using?

Airtable has its own settings for dates that do not always match the computer settings.
By default, Airtable dates are MM/DD/YYYY.

Airtable thinks that 03/08/2021 is March 8, 2021.
If you want that 03/08/2021 to be 3 August 2021, I recommend changing the format of your date field to be “European”. You may find that you need to redo your data entry.

When you format your date using DATETIME_FORMAT you have the option of setting both the locale and the order of the elements in the date. Setting the locale in the DATETIME_FORMAT only changes the words used, not the order of the words.