Changing date format

[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

 

[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

 

[Dudley]

Thanks very much. it worked perfectly.
Dudley

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