Re: Display month name

692 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator


I'm trying to create a field to display the month name. My start column is EU dates like that : 


Precision, sometines the number of the month is unique "6, 7, 8" but from october, it switch to a double number "10, 11 or 12".

Any idea ? 🙂

3 Replies 3
Airtable Employee
Airtable Employee

Hi Julien! It sounds like you might want to reference our list of format specifiers for the DATETIME_FORMAT function to accomplish this, as well as our guide on SET_LOCALE to match the locale formatting specifically.

Let me know if this is along the lines of what you're searching for!

6 - Interface Innovator
6 - Interface Innovator


It works, thanks a lot Juliana!

Last point, I was looking to translate the months names in french 🙂

For the frenchies, this is the solution :  


  SET_LOCALE({colonne_date}, 'fr'), 


Thanks for posting your solution, Julien! Glad to hear that this could get the workflow up and running for you. 😊