Help

Re: I need help on a date conversion formula

3603 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Philippe_Creve_
5 - Automation Enthusiast
5 - Automation Enthusiast

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

4 Replies 4
Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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"
)

Ben_Young1_0-1675135924989.png

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

 

Hello Matt,

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

Hello Ben,

Thank you very much for your quick response,

It's awesome