Date Format

server administration XI Server Discussion
1

Hi

We migrated from BO 65. to BO XI 3.0, we observed that date format with in the reports is converted to american date format and this is causing our migration test to fail.

Has anyone got any idea how to resolve the date format issue.

venkatpuram (BOB member since 2008-07-25)

2

Ensure you have the correct ‘Preferred Viewing Locale:’ set in your preferences, this will affect the default date format.

FionaCasey :ireland: (BOB member since 2007-01-22)

3

Hi Thanks for your reply, I tried various options including changing the server regional settings and locales, it did not work. Finally I changed the date format in sqlsrv.prm file on the web I server to ‘dd/mm/yyyy’ and re booted the server. Now all looks fine.
The link below helped me in sorting out the issue.

[/url]Out-Of-Range Date Time Value:WIS 10901

venkatpuram (BOB member since 2008-07-25)

4

Hi Thanks for your reply, I tried various options including changing the server regional settings and locales, it did not work. Finally I changed the date format in sqlsrv.prm file on the web I server to ‘dd/mm/yyyy’ and re booted the server. Now all looks fine.
The link below helped me in sorting out the issue.

[/url]Out-Of-Range Date Time Value:WIS 10901

venkatpuram (BOB member since 2008-07-25)