[AccessD] export dates using transfertext A2K

Hi Rob,

You need to use a format function to convert your date to a text string.

FormattedDateField:Format(YourDateField,"mm-dd-yyyy")

Gary Kjos
garykjos at hotmail.com





>From: "Rob Chivers" <rob at consulting.com.au>
>Reply-To: accessd at databaseadvisors.com
>To: "Database Advisors" <accessd at databaseadvisors.com>
>Subject: [AccessD] export dates using transfertext A2K
>Date: Thu, 10 Apr 2003 08:25:33 +0800
>
>
>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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus