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
|
|||
|
|||
updating date format
I imported a table and the date format is Aug 24 2004. I
want to change that to a standard mm/dd/yy format. I would like to automate this process. Can I do this change using an update query and if so how? |
#2
|
|||
|
|||
What data type is the field? If it is a date/time field, then all you need
to change is the format for that field and/or the controls that display it. If the field is text, it can be changed using an update query, but usually you will want the field to be a date/time type. Also, I would recommend 4 digit years. UPDATE Table1 SET Table1.Field1 = Format(CDate(Table1.Field1), "mm/dd/yy"); -- Wayne Morgan Microsoft Access MVP "john c" wrote in message ... I imported a table and the date format is Aug 24 2004. I want to change that to a standard mm/dd/yy format. I would like to automate this process. Can I do this change using an update query and if so how? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date format Actual to month only | RC | General Discussion | 9 | August 25th, 2004 01:30 PM |
Mail Merge Date Format Problem | Nick | Publisher | 2 | August 17th, 2004 04:55 PM |
Date Format | Date Formating Problem | Database Design | 3 | August 16th, 2004 06:41 PM |
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 |