changing date format

  • Thread starter Thread starter john
  • Start date Start date
J

john

Help... I am importing data with a date field which is
set up as Aug 24 2004. I would like to change that
format to mm/dd/yy. Can I do this using an update query?
This is not a one time deal and I would like to automate
the process.
Thanks
 
When you store a date in Access, it is actually storing a serial number that
represents a date and time. If you are importing these items into a "date"
field, then the format does not really matter. You can modify the format in
your table design, report design, etc.

Don't worry about how it is imported, just make sure your field is formatted
the way you want in the design-view. Then, when you open your table (with
the imported data) it should look the way you want.

If your field is not a "date" field, then you have another issue.


Rick B


Help... I am importing data with a date field which is
set up as Aug 24 2004. I would like to change that
format to mm/dd/yy. Can I do this using an update query?
This is not a one time deal and I would like to automate
the process.
Thanks
 
Back
Top