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
Aug 07, 2019 01:02 PM
I have a date field including M/DD/YYYY. I want to have a formula column that will use the date field to display just the name of the month in this format “01-January.” Being new to formulas I’m not sure how to do this.
At first, I tried to identify the month using IS_BEFORE and IS_AFTER. That seemed cumbersome since it has to deal with the entire date. Then, I thought perhaps I could just identify the month within the string and repeat it with text, but I don’t know how to do that efficiently and couldn’t find a help thread that would explain parsing data that way.
Any help would be appreciated.
Aug 07, 2019 01:13 PM
Take a look at the Supported format specifiers for DATETIME_FORMAT.
It seems that you want the month number followed by the month name, with a hyphen in between.
With the DATETIME_FORMAT function, ‘MM’ will display the number of the month (with a preceding zero if necessary), and ‘MMMM’ will display the month name.
So, if your date field is “Date Field”, then use the formula:
DATETIME_FORMAT({Date Field},‘MM-MMMM’)
(Edited post to change “M” to “MM”.)