Date/Time format in CMC

server administration XI Server Discussion
1

I have to change the date/time format from MM/DD/YYYY in the CMC to the Australian date/time format of DD/MM/YYYY.

Does anyone know how this is done?

I’m running CR Server XI R2 on RedHat Ent AS and Tomcat

TommyD :canada: (BOB member since 2007-08-29)

2

Does anyone have any thoughts on the date/time problem I’m having?

TommyD :canada: (BOB member since 2007-08-29)

3

Hi,

Did you try to log on the CMC/Preferences and change the time zone?

Regards

4

Hi G&F,

The Preferences in CMC have been changed to the correct time zone, but the data/time is still fomatted in MM/DD/YYYY not DD/MM/YYYY.

InfoView on the other hand is displayed properly as DD/MM/YYYY.

Any thoughts?

TommyD :canada: (BOB member since 2007-08-29)

5

I’ve been dealing with a similar issue where some reports were clearly defaulting to the US format (MM/DD/YYYY).

I resolved this by amending the Date Format String in the sqlsrv.prm file. This is the parameter file for SQL Server, and there should be an equivalent file for whichever database you are using. Try checking out this file to see what the settings are currently.

The file location will be something like this:
C:\Business Objects\Business Objects Enterprise xx.x\Win32_x86\dataAccess\ConnectionServer\odbc\

My file entry looks something like this:
…
‘dd/mm/yyyy HH:m:s’
…

Julian

jstrakerj (BOB member since 2007-05-29)