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

IF formula for dates

Topic Labels: Formulas
566 1
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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:

(Edited post to change “M” to “MM”.)