Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Month Formula - Name instead of Number

Topic Labels: Formulas
598 2
Showing results for 
Search instead for 
Did you mean: 

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,

Listed Month (formula)|408x331 Listed Month

2 Replies 2

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: