- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 30, 2023 03:40 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 30, 2023 07:30 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 30, 2023 07:32 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 31, 2023 04:26 AM
Hello Matt,
Thank you very much for your quick response, it helps me a lot.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 31, 2023 04:34 AM
Hello Ben,
Thank you very much for your quick response,
It's awesome