- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 12:31 PM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 01:24 PM
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')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 01:24 PM
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')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 01:36 PM
That is EXACTLY what i needed. Thank you!!
