date as YYYYMMDD

D

dkingston

I'm importing a table to Access 2002 using ODBC and the
date field in the oringinal table is in YYYYMMDD format.
Can Access recognize this format and convert it to MMDDYY?
If so, how do I set it up?
 
K

Ken Snell

Import the data into a temporary table, then use an append query that copies
the data into the permanent table. Use a calculated field similar to this
for the "date" field:

ChangeDate: CDate(Mid([DateField], 5, 2) & Right([DateField], 2) &
Mid([DateField], 3, 2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Birth Date format 1
Inserting slashes in dates in Excel 1
Date format on exporting query to csv file from access 2007 3
Access 07 import yyyymmdd 1
Converting Text to Date 3
Convert a yyyymmdd date format in code 4
Text File Import Fails on YYYYMMDD data field, worked great in Acc 3
how do I convert date format yyyymmdd to mm/dd/yyyy 2

Top