Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Date Formatting With An 'IF' Function

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

I’m trying to figure out how to use an IF statement with DATETIME_FORMAT({Birth Date}, ‘MMMM Do’).

Basically, I’m formatting the Birthday Field from the raw Birth Date field to remove the year and to put the date in a more reader-friendly format. However, when a birth date is missing, I get #ERROR. Is there a way to do an IF statement with an IF({Birth Date}=BLANK(),“Birthday Missing” with the DATETIME_FORMAT({Birth Date}, ‘MMMM Do’) as well? I tried just combining the two, but it won’t accept it as a valid format.

Here’s screenshots of the fields:
Screen Shot 2021-03-16 at 3.38.31 PM Screen Shot 2021-03-16 at 3.38.15 PM

Thanks for your help! I’m new to Airtable so not so great yet.

1 Reply 1

The IF function can take either two or three parameters. It looks like you want three.

  condition being tested followed by a comma,
  what to show if the condition is true followed by a comma,
  what to show if the condition is false with no comma at the end 

I also find it easier to test if a field has a value, versus testing if it is blank.

  {Birth Date},
  DATETIME_FORMAT({Birth Date}, "MMMM Do"),
  "Birthday missing"