If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Format HELP
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 |
#2
|
|||
|
|||
Date Format HELP
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") -- Duane Hookom MS Access MVP "John Vercelletto" wrote in message ... 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 |
#3
|
|||
|
|||
Date Format HELP
John Vercelletto wrote:
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. Try: SELECT Format(DateShipped, "mm/dd/yyyy") As ShipDate ... -- MGFoster:::mgf00 at earthlink decimal-point net Oakland, CA (USA) |
#4
|
|||
|
|||
Date Format HELP
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". -- HTH Van T. Dinh MVP (Access) "John Vercelletto" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Dilema! | Kagsy | General Discussion | 8 | July 13th, 2004 03:45 AM |
Date format for Track Changes | Stuart K | New Users | 1 | June 13th, 2004 11:09 AM |
Track change Author/Date popup shows US date format not correct regional set | Wayne Zaunders | New Users | 1 | May 23rd, 2004 11:57 AM |
Pivot Table - Format of Date Field | Peo Sjoblom | Worksheet Functions | 0 | February 3rd, 2004 07:20 PM |
Changing date format to text only | Worksheet Functions | 0 | January 1st, 2004 07:37 AM |