Date Format Question

  • Thread starter Thread starter F red
  • Start date Start date
F

F red

Hi, I imported a date field from a legacy system with the following format
20040513, (YYYYMMDD) my problem is I can't seem to figure out how to make
access look at the data in this field as a date. Any help would be
appreciated... I am somewhat new at access...
 
F red said:
Hi, I imported a date field from a legacy system with the following format
20040513, (YYYYMMDD) my problem is I can't seem to figure out how to make
access look at the data in this field as a date. Any help would be
appreciated... I am somewhat new at access...
Click to expand...

Generally when you need to "massage" imported data, it is best to import into a
work table and then do the cleanup on the work table data. In your case if the
work table stored the value as a number you could then use a query expression
of...

CDate(Format([YourField], "0000/00/00"))
 
Back
Top