I have a simple query that works out a a date 1 day before a babies first birthday.

B_E_D: [Children]![Date of Birth]+364.3333

What i want to do is get the query to return the B_E_D in a date format rather than a number.

Can you help??

Thanks in advance

Look up the DateAdd function

In the properties of your calculated field, change the format value to YYYY/MM/DD or whatever you want.