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 :
thank you in advance
Hi Philippe, see attached screen shots if you are more visual.
Based on your example, that would do it:
--
--
There might be other ways to do it. Hope it helps.
Cheers.
Matt
+9Hey @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:
--
--
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
