Hello all,
I have been desperately looking on the internet on how to make a query to calculate age in years and months between two dates. For example the two dates I am using is [DOB] (date of birth) and [DateDx] (date of diagnosis) from those two dates I would like to calculate [AgeDx] (age at diagnosis). I would like it read 2y 3m.
I found this equation: iif(Format([ContCancDate]-[ContStartDate],"yy"" yrs ""mm"" mths""")="99 yrs 12 mths", "0 mths",Format([ContCancDate]-[ContStartDate],"yy"" yrs ""mm"" mths"""))
but when I click "Show" and select the Table I wish to show it in then I get a syntax error about commas. But if show is checked but a table is not specified to show the calculation then it will save and work. But the problem is then I cant see it in the original table.
Please help.
Thank you,
Lenny