Date Format

chrisjnelson

New member
Local time
Today, 02:06
Joined
Jan 22, 2002
Messages
9
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
 
In the properties of your calculated field, change the format value to YYYY/MM/DD or whatever you want.
 

Users who are viewing this thread

Back
Top Bottom