Changing date format

  • Thread starter Thread starter Dudley
  • Start date Start date
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
 
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
 
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
Click to expand...
Click to expand...
 
Back
Top