Display Month Number & Month Name

[Julien_Etoke]

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

[Juliana]

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]

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'
)

[Juliana]

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