Hey there
I still don’t get AirTable to the fullest and would appreciate some help. I got a database with Birth Dates and managed to find out peoples ages with the TONOW formula.
I would want a second row telling me wether the Date filed is more then 4380 days ago or not.
I tried something like IF(Date > 4380 days ago , “True”, “Not True”)
As this does not work - what can I do instead?
Thx for any hint.
Best answer by Vivid-Squid
Here is a good formula for getting a person’s age
DATETIME_DIFF(TODAY(),{Date of Birth},'years')
Here is a formula for finding out if a date is more than 4380 days ago
IF(DATETIME_DIFF(TODAY(), {Date of Birth}, 'days')>4380, 'true', 'not true')
+16Here is a good formula for getting a person’s age
DATETIME_DIFF(TODAY(),{Date of Birth},'years')
Here is a formula for finding out if a date is more than 4380 days ago
IF(DATETIME_DIFF(TODAY(), {Date of Birth}, 'days')>4380, 'true', 'not true')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.