I need help on a date conversion formula

[Philippe_Creve_]

Hello, I need help on an airtable formula. I have a date conversion formula: but I would like if the table is empty it says "Enter your birthday date" To avoid the error message please 

my formula : 

DATETIME_FORMAT(Dateofbirth, 'DD MMMM YYYY')

thank you in advance

[Matt_Boudreau]

Hi Philippe, see attached screen shots if you are more visual.

Based on your example, that would do it:

--

IF(Dateofbirth, DATETIME_FORMAT(Dateofbirth, 'DD MMMM YYYY'), "Enter your birthday date")

--

There might be other ways to do it. Hope it helps.

Cheers.

Matt

[Ben_Young1]

Hey @Philippe_Creve_ !

Here's a formula that accomplishes what you're looking for:

IF(
  {Date},
  DATETIME_FORMAT(
    {Date},
    "DD MMMM YYYY"
  ),
  "Please Enter Your Birthday"
)

Feel free to pop your own preferred message into the formula if you'd like to change it around.

[Philippe_Creve_]

Hello Matt,

Thank you very much for your quick response, it helps me a lot.

[Philippe_Creve_]

Hello Ben,

Thank you very much for your quick response,

It's awesome