Stuart McLachlan
stuart at lexacorp.com.pg
Sat Feb 1 16:35:00 CST 2003
> As part of the application I am building, I have to
> Import the data using the following code.
>
> DoCmd.TransferText acImportDelim, "BVH", "RawImport",
> "C:\Program Files\Leadnet\Data\LEAD.txt"
>
> I made a schema to separate the fields. Can I do
> anything at that point to change the Date from mmddyy
> to mmddyyyy? I am importing fifty records at a time
> give or take.
>
> I am fixing this data with a query and don't know how
> to apply your suggestion in a query.
>
In your query, use
IIF(year(PatDOB) > 1999,DateAdd("yyyy",-100,PatDOB),PatDOB) as the source of the
date field.
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.