I have an age formula that returns an “error” if no birthday is available. How do I remove the “error”
Solved
I have an age formula that returns an "error" if no birthday is available. How do I remove the "error"
Best answer by Jeremy_Oglesby
The above didn’t work for me.
But this worked okay.
IF({Birthday}=BLANK(),BLANK(),DATETIME_DIFF(NOW(),{Birthday},‘years’))
Hey @John_Buttner
I wrote that post before I had a realization that straight quotes were constantly being converted to curly quotes in the forum editor 😆. Those curly quotes in my answer above cause problems in the Airtable formula editor.
Glad you found a variation that works for you. Just want to follow up that for clarity’s sake, your (and my) formulas can be simplified to this:
IF(Birthday, DATETIME_DIFF(NOW(),Birthday,'years'))
And I’ve carefully vetted that for the right type of quotes!
Hi Greg, were you able to fix this? I’m having the same issue
You can use a conditional statement to return a blank cell if the “Birthday” field is empty:
IF(Birthday, DATETIME_DIFF(NOW(),Birthday,’years’),BLANK())
That should do it.
You can use a conditional statement to return a blank cell if the “Birthday” field is empty:
IF(Birthday, DATETIME_DIFF(NOW(),Birthday,’years’),BLANK())
That should do it.
The above didn’t work for me.
But this worked okay.
IF({Birthday}=BLANK(),BLANK(),DATETIME_DIFF(NOW(),{Birthday},‘years’))
The above didn’t work for me.
But this worked okay.
IF({Birthday}=BLANK(),BLANK(),DATETIME_DIFF(NOW(),{Birthday},‘years’))
Hey @John_Buttner
I wrote that post before I had a realization that straight quotes were constantly being converted to curly quotes in the forum editor 😆. Those curly quotes in my answer above cause problems in the Airtable formula editor.
Glad you found a variation that works for you. Just want to follow up that for clarity’s sake, your (and my) formulas can be simplified to this:
IF(Birthday, DATETIME_DIFF(NOW(),Birthday,'years'))
And I’ve carefully vetted that for the right type of quotes!
Hey @John_Buttner
I wrote that post before I had a realization that straight quotes were constantly being converted to curly quotes in the forum editor 😆. Those curly quotes in my answer above cause problems in the Airtable formula editor.
Glad you found a variation that works for you. Just want to follow up that for clarity’s sake, your (and my) formulas can be simplified to this:
IF(Birthday, DATETIME_DIFF(NOW(),Birthday,'years'))
And I’ve carefully vetted that for the right type of quotes!
I new at AirTable but have MSoft Access programing experience.
Yep that works and I like it much better.
Thanks for the simplified code. :slightly_smiling_face:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.