Changing date format


D

Dudley

I have a query field

DirDOB: IIf(Not IsNull([DOB]),"4032=" & [Director].[DOB])

DOB is a date field displaying (British style) dd/mm/yyyy. How do I get it
to display in the query as yyyy-mm-dd?

Thanks for any help.
Dudley
 
Ad

Advertisements

J

John Spencer

One method would be to use the Format function;

DirDob: Format([Director].[Dob],"\4\0\3\2\: yyyy-mm-dd")

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Ad

Advertisements

D

Dudley

Thanks very much. it worked perfectly.
Dudley

John Spencer said:
One method would be to use the Format function;

DirDob: Format([Director].[Dob],"\4\0\3\2\: yyyy-mm-dd")

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I have a query field

DirDOB: IIf(Not IsNull([DOB]),"4032=" & [Director].[DOB])

DOB is a date field displaying (British style) dd/mm/yyyy. How do I get it
to display in the query as yyyy-mm-dd?

Thanks for any help.
Dudley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Field 3
Update query 2
Update query 1
Formatting date gives bad results in query 2
QUERY DESIGN 2
extract just month/year from table field?? 2
Date Function in query 3
Date format in query export. 4

Top