Outlook allows you to define your own fields and they can contain formula. So I used the standard field of BIRTHDAY and created a field for AGE etc. I have views set up for my Children and Grandchildren and wanted to have their age shown. For the age of the child I use the formula.....
IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d", CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"")
That works well but would like it to show 2 decimal places and am working on trying to figure that out.
For my past relatives I used their BIRTHDAY and created a simple formula as
([Death Date] - [Birthday] )/ 365.25
And come up with an answer of 56.223342211 or something like that. I would like to have it give me 56.2 or 56.22
|