Calculating an Age field

[katc]

I am calculating the age of a file. I have two fields I want to calculate the difference in age or years (one is in a form and the other in a subform). The field names are: DOB and CaseDate. I used the following to calculate: DateDiff("yyyy", Forms!EnterPatient!DOB, Forms!EnterPatient!Case.Form!CaseDate) + (Forms!EnterPatient!Case.Form!CaseDate < DateSerial(Year(Forms!EnterPatient!Case.Form!CaseD ate), Month(Forms!EnterPatient!DOB), Day(Forms!EnterPatient!DOB))) However, for a file that is not yet a year, it only returns 0. Does anyone know of a way to have it return a decimal for less than a year? Thanks.

[orange]

Why don't you use dateDiff to show Months or Days?
Would you or anyone else relate to .038 years? (which is about 14 days)

[ssanfu]

The "yyyy" causes the difference to be in years.
You could use "m", which would return the number of months, then divide by 12 to get years. So if DateDiff() returned 18 months, dividing by 12 would return 1.5 years. if DateDiff() returned 6 months, dividing by 12 would result in .5 years.

[katc]

Steve,
Prefect. I was just messing with "d" and then dividing by 365.25. However, "m" /12 is even better!
Thank you for your wisdom!
Cheers!