Skip to main content

IF formula for dates

  • August 7, 2019
  • 1 reply
  • 0 views
J

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

C
  • Claudio
  • Participating Frequently
  • 28 replies
  • August 7, 2019

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

Reply


Most helpful members this week

Terms & Conditions