Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Month Formula - Name instead of Number

1629 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah_Holmes
4 - Data Explorer
4 - Data Explorer

Hello,
Just wondering if it’s possible for the Month formula to show the month instead of just the number?
Example attached. Any help would be very much appreciated :slightly_smiling_face:
Thank you,
Sarah

Listed Month (formula)|408x331 Listed Month

2 Replies 2
Marko_Petrovic
7 - App Architect
7 - App Architect

I don’t know what is current formula that you use, but you can use DATETIME_FORMAT() on your date field and that use MMMM as format specifier which will return month as January, February, etc.

You can see all options for this function here:

Thank you so much! That worked :slightly_smiling_face: