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)
 
Top