Show number of days in query table instead of year.

[jessicatran]

Hi,

In the query table... the expression is:
Age: DateDiff("yyyy",[DateOfBirth],Date())+(Format(Date(),"mmdd")<Format([DateOfBirth],"mmdd"))

This only output the number of year.

How can I write to output number of days?

Thanks,
Jessica

 

[boblarson]

Use the DateDiff function in the query

DaysOld: DateDiff("d",[YourDateFieldHere],Date())

 

[jessicatran]

Wow.. that was easy... thanks.

Jessica

 

[RuralGuy]

Something like this?