Not able load d file in date format

[sudipta]

Hi,

In my UAT database in tab1 i have a date column in mm/dd/yyyy format. I am able to load dfile for that table.
But in my production in same table in same field in same format I am not able to the the same d file.
I am getting the below error.

>> ERROR READING LINE #1 (Offset=0): ** The month of a date must be from 1 to 12. (80)
** Tolerable load error rate is: 0%.
** Loading table AccCentres is stopped after 1 error(s).

In both prod & UAT owner of the table is same.

Can any one help me

 

[TomBascom]

You probably have a different date format being used. mdy on UAT and dmy on production.

A quick test is to start a session on each and execute the following 4GL:

display session:date-format.

Look for the -d client startup parameter. It might be in $DLC/startup.pf or in any client .pf file or on the command line (or in a shortcut if this is Windows).

 

[sudipta]

Thanks a lot.
Yes in UAT it's mdy and in production it's dmy.
Please tell me how to change it to mdy in prod.

 

[sunilnair]

session:date-format = 'mdy'.

 

[sudipta]

Thanks a lot. I think to change it permanently I need to modify startup.pf file.