Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Date is before 4380 days ago

Topic Labels: Formulas
Solved
Jump to Solution
926 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Giegeric
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

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')

See Solution in Thread

1 Reply 1
Vivid-Squid
11 - Venus
11 - Venus

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')