Change date format in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to make a date format in a table to be mmddyy, but -- how do I get
that same mmddyy format to appear in my query results?? It keeps reverting
back to a standard date format. Thank you.
 
Rhonda:

One alternative is to use the Format function. For example:

SELECT MyTable.MyDate, Format([MyDate],"mmddyy") AS FormattedDate
FROM MyTable;

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I know how to make a date format in a table to be mmddyy, but -- how do I
get
that same mmddyy format to appear in my query results?? It keeps reverting
back to a standard date format. Thank you.
 
Back
Top