date format

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All
I have imported some data that has a date field in the format yyyymmdd. The
rest of my database has dates as ddmmyyyy, so I don't want to change the
setting in control pannel. I'm sure there must be an easy way of converting
the field in my imported data to ddmmyyyy format but I can't seem to get it,
so if anyone can help I would be extremely grateful.
Thanks
Les
 
G'morning, Leslie

Check the DateSerial() function if you want to convert the data to a
date/time value. You can use the Left(), Mid() and Right() functions to
"extract" the 'dd', 'mm', and 'yyyy' components.

When you say your database has dates as ddmmyyyy, do you mean you literally
are storing a text-type field with that structure, or are you using that
format to display your date/time field values?
 
Back
Top