Date Conversions

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I am importing a raw data file, fixed width. There is a
date field in the text file that looks like:

031014

YYMMDD is the format.

When I put Date/Time format in the Access table it errors
out due to conversion type failure. How can I make Access
understand this?

Thanks
 
I am importing a raw data file, fixed width. There is a
date field in the text file that looks like:

031014

YYMMDD is the format.

When I put Date/Time format in the Access table it errors
out due to conversion type failure. How can I make Access
understand this?
Click to expand...

Use the DateSerial() function:

DateSerial(left([DateValue],2),mid([DateValue],3,2),right([DateValue],2))

"DateValue" would be the name of the field that you are converting.
 
Back
Top