DATETIME_DIFF() - Mixing up the age of living and dead “people”? [SOLVED]
Hi there ! :grinning:
I’m very very new here, on Airtable, so to begin gently, I’ve come up with the idea to build a DB regrouping all the info I have on the pets I lived with (dead and alive).
But I’ve got a DATETIME_DIFF() formula difficulty.
On my base, I’ve created kind of a summary table with all the general info concerning the pets (Species, race, gender, etc…)
On this table, I’ve got a field Date of Birth (DoB) and a field Date of Death (DoD).
What I would like to do is to create a field that would give me the actual age of the pet (if still alive) or the age of the pet when it died, on same table, if possible :winking_face: .
Reading the help documentation and many topics here concerning the DATETIME_DIFF() formula I found this :
DATETIME_DIFF(TODAY(),{DoB},’years’)
Which works perfectly for the actual age of the living pet.
