calculating age in a report

[Lianne Wendt]

I would like to calculate age of my clients from my table in a report that includes their name and date of birth. I am having trouble figuring out the formula to put in the text box to do it. Can anyone help.

Thanks

 

[Cosmos75]

Use the function DateDiff()

e.g.
DateDiff("d",[Birthday],Date())

Date() returns todays' date.

 

[KeithB13]

Try looking at the "DateDiff" funciton in the help menu. I think you will find what you are looking for.

Good luck,
Keith

 

[Fornatian]

from a search of THIS forum:

Age: DateDiff("yyyy", [DOB], Date()) + (Date() < DateSerial(Year(Date()), Month([DOB]), Day([DOB])))