Calculation Query Which returns age in years and months between two dates

[Leonidsg]

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

[qa12dx]

took me a long time, tons of sweat & tears to figure it out. (pre google era)

what u want is datediff function

see how i did it. modify to suit ur needs. the "how u want to see it" is what u r trying to figure out. also included some more examples.

i like this forum and don't want to point u to a outside web page, but there r lots of examples out there.

cheers