Help

Re: Converting date to text

Solved
Jump to Solution
826 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Limi
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
Darryl_Oliver
6 - Interface Innovator
6 - Interface Innovator

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

See Solution in Thread

2 Replies 2
Darryl_Oliver
6 - Interface Innovator
6 - Interface Innovator

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