Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

IF Date is before 4380 days ago

Topic Labels: Formulas
Solved
Jump to Solution
577 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')