Skip to main content

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

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"

)

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

 

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


Hello Matt,

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

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.

 


Hello Ben,

Thank you very much for your quick response,

It's awesome

 

Reply


Terms & Conditions