Re: Date Format Question

message from Rick Brandt on 13 May 2004
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"))
 

Archived message: Re: Date Format Question (Microsoft Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.