[AccessD] Exporting to .txt

SELECT SSN, Format([PayDate], "mmddyyyy"), Format([PeriodEndDate],
"mmddyyyy"
FROM op_TALX

Charlotte Foust

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Friday, December 12, 2003 9:43 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Exporting to .txt


Where can I do format ? in sql window of query ?

SELECT SSN, PayDate, PeriodEndDate
FROM op_TALX

here ?

> You need to do the export from a query and use the format function to 
> change the date to a string of the correct format.  If you just export

> from the table, a date is going to be handled as a date.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> Sent: Friday, December 12, 2003 9:05 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Exporting to .txt
>
>
> I need to export a file to either .scv or .txt format with fixed 
> length. There are 2 date fields which should be in a mmddyyyy format. 
> I specify in 'specification' that field should have be in a format 
> MDY, 4 digit year. leading zeros, no dividers, yet I still get 
> 12/7/2003 type results... in txt file..
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now. 
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com