Hi there !
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 .
Reading the help documentation and many topics here concerning the
DATETIME_DIFF() formula I found this :
Which works perfectly for the actual age of the living pet.
Which works perfectly for the age of the pet when it died.
If I get it right, I would need to create a
IF() nested formula mixing both of these ones above, but after many tries I can’t find my way around this…
Could someone help me ?
Thanks a lot, in advance
(PS: Sorry for my English … It’s not my mother language )