[AccessD] export dates using transfertext A2K

Set the formats for the dates in the queries themselves instead of the
tables.
 
 
John V. Ruff - The Eternal Optimist :-) 

"Commit to the Lord whatever you do, 
        and your plans will succeed." Proverbs 16:3 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rob Chivers
Sent: Thursday, April 03, 2003 9:10 PM
To: AccessD
Subject: [AccessD] export dates using transfertext A2K


Hi
I am exporting from a table to a text file with dates but keep getting the
time in the exported date even though it doesn't appear in the table.
I have tried setting the date to dd-mmm-yyyy in table field but works on 1
table but not on another table.
I have manually set up an export specification (eg ExportLeaseSpecification
) for each table using ; delimiter and none for text qualifier and : for
time separator.
 
Code is:
'following queries export to tmpPASwinExportLease and has 3 date fields with
format dd-mmm-yyyy
    DoCmd.OpenQuery "qappExportLeaseHeader"
    DoCmd.OpenQuery "qappExportLease"
    ExportPASwinFile "ExportLeaseSpecification", "tmpExportLease",
"ExportLease.txt"
 
The export works fine but results in 
 
17;21/03/2003;555;;;;;;;;;;;;;;;;;;;;;
1;N;070;ca;;;;2;12/04/1999;11/4/2004 0:00:00;;;;0;;;;;;;28/3/2003 14:10:56;
2;N;070;cip;;;;2;1/07/2000;30/6/2004 0:00:00;;;;0;;;;;;;28/3/2003 14:10:56;
 
and what I want is 
 
17;21/03/2003;555;;;;;;;;;;;;;;;;;;;;;
1;N;070;ca;;;;2;12/04/1999;11/4/2004;;;;0;;;;;;;28/3/2003;
2;N;070;cip;;;;2;1/07/2000;30/6/2004;;;;0;;;;;;;28/3/2003;
 
Can anybody help?
 
Thanks
Rob
 
 
 
 
 
 
 
 
 
 
 
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030403/4f3c5bb4/attachment-0001.html>