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.
Solved
Converting date to text
Best answer by Darryl_Oliver
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')
+8Limi,
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!!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.