# IF Date is before 4380 days ago

Topic Labels: Formulas
Solved
398 1
cancel
Showing results for
Did you mean:  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  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')
``````  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')
`````` 