Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Fri Dec 12 12:15:32 CST 2003
HURRRAAAAYYYYYYYYYYYYYYY !!!!! Thank you > 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 > _______________________________________________ > 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