Display month name | Airtable Community

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 ? 🙂

Page 1 / 1

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!

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'

)

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!

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

Sign up