Help

Re: Display month name

1347 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

Hello!

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

10/6/2023

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
Juliana
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!

Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

Hey!

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 :  

 

DATETIME_FORMAT(
  SET_LOCALE({colonne_date}, 'fr'), 
  'MMMM'
)

 

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