IF formula for dates

Topic Labels: Formulas
850 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
6 - Interface Innovator
6 - Interface Innovator

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”.)