[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