Export table to file date format error

[Andyfives]

Hi there somebody please help me!!

Paradox v5
We have transfered data from Paradox to a fixed length text file for the last 5 years no problems..

It runs on schedule every day. Until yesterday, instead of giving the expected Padded Euro date format dd/mm/yyyy (27/02/2002) it decided to output US m/d/yyyy (2/27/2002) instead. Nothing has changed on the PC this runs on.

I execute a query to place the current days data in a table. Then use the following line of code:-

exportASCIIFix(":NETPRIV:ANSWER.db" , ":NETPRIV:VoyRPT.txt",":NETPRIV:VoyRPT11.db",True)

to export it to a text file. It has to be fixed length as its destination is our AS400.

Changed the date on the PC, same error. Tried different dates to export varied data. Same error.

Has anyone come across this problem before?? Does anyone have anymore ideas then me?

Thanks in advance

Andy

 

[Andyfives]

Problem solved!
Our Database Administrator for the app changed the ODBC driver and set something to an International setting.
Cheers anyway