Skip to main content

Is there a formula I can use to convert a date (6/28/2023) to a text (June 2023)? It'll make it easy for me to group by that month.

Limi,

Take a look at the Date & Time functions in the Formula Field Reference.

I believe your solution will look something like this: DATETIME_FORMAT({Date Field},'MMMM YYYY')

Limi,

Take a look at the Date & Time functions in the Formula Field Reference.

I believe your solution will look something like this: DATETIME_FORMAT({Date Field},'MMMM YYYY')


That is EXACTLY what i needed. Thank you!!

Reply


Terms & Conditions