Date Format HELP

J

John Vercelletto

I know this is probably and easy one, I have done it
before, but blanking out now.

I have a date/time field (DateShipped) and I am creating
a query from the table containing this field. I need
this field to be in the format mm/dd/yyyy. Currently for
July 7, 2004 it shows 7/7/04 and I can't seem to get it
to show 07/07/2004 no matter what I try.

Thanks in advance for your help!

John
 
D

Duane Hookom

I would set the format in the form or report you are opening rather than in
the query. If you want to do this in the query, you can try
Ship Date:Format([DateShipped],"mm/dd/yyyy")
 
M

MGFoster

John said:
I know this is probably and easy one, I have done it
before, but blanking out now.

I have a date/time field (DateShipped) and I am creating
a query from the table containing this field. I need
this field to be in the format mm/dd/yyyy. Currently for
July 7, 2004 it shows 7/7/04 and I can't seem to get it
to show 07/07/2004 no matter what I try.
Click to expand...

Try:

SELECT Format(DateShipped, "mm/dd/yyyy") As ShipDate ...
 
V

Van T. Dinh

You can also set the Format Property of the Field in the Query.

Open the Query in DesignView, click on the required Date Field Column, open
the Field Properties window then set the Format Property to "mm/dd/yyyy".
 
Top