Age

[damsel]

My database is for kindergarten. Is there a way that I can calculate the kids' age from their date of birth field?
I have tried using the datediff function, however I want it to be exact like 1.3 (1 year and 3 months old). Many thanks

 

[simongallop]

Here's one way:

age: Format(Date()-[DOB],"yy mm")

it will return 05 07 for 5years 7months