[AccessD] Date Format

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.






More information about the AccessD mailing list