Date Formatting With An 'IF' Function

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.15 PM

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

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

IF(
  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.

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.