How to change from US to UK date format?

system · August 21, 2009, 3:42pm

Hi,

We have BOXI 3.1 installed on our test server. I wasn’t involved duriing the installation process, so not sure if it is one of the parameters you set during installation. I have test migrarted a few reports from our 6.x version to this test server, but dates in all the reports appear in US format, MM/DD/YYYY.

My question is how do we change this to UK format, DD/MM/YYYY?
I have searched the forum and tried changing the INPUT_DATE_FORMAT in the following files:

\Server\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\Oracle\oracle.prm

The INPUT_DATE_FORMAT in this oracle.prm was already in dd-MM-yyyy

What I am not sure is which prm file needs changing. My reports query different RDBMS (oracle, sql server, sybase etc.). So, I am guessing there will be central setting for date format somewhere, but not sure where?

Please anyone could help me with this?

Thanks,

Ilovebo (BOB member since 2006-10-17)

system · August 22, 2009, 8:00pm

Hi,

You are not on the right track.

Based on my memory:

infoview: go to prefences and should be on the second tab on the left

Deski: go to tools—> options—>languges.

John

john.sc3rd (BOB member since 2009-05-24)

system · August 24, 2009, 8:29am

Thanks John, for your reply.

I know that it can be set DeskI by using tools—> options—>languges.

But, we need can’t do this for 600+ BO users that we have, are you aware of any other global setting that we use to for all our DeskI installations?

Many thanks once again.

Ilovebo (BOB member since 2006-10-17)

system · August 24, 2009, 12:29pm

Canyou please change the .prm file in the following path

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\oracle\extensions\epm

krishnak (BOB member since 2008-06-27)

system · August 24, 2009, 12:34pm

Krish,

I have checked the oracle.prm in the location you specified.

<?xml version="1.0" encoding="UTF-8"?>

<Configuration>
    <Parameter Name="EPM_DATE">TO_DATE('%1-%4-%6', 'DD-MM-YYYY')</Parameter>
    <Parameter Name="EPM_TIME">TO_DATE('%9-%10-%11', 'HH24-MI-SS')</Parameter>
    <Parameter Name="EPM_DATETIME">TO_DATE('%1-%4-%6:%9-%10-%11', 'DD-MM-YYYY:HH24-MI-SS')</Parameter>
    <Parameter Name="EPM_CDZTEXTDT">%6-%4-%1 %9:%10:%11</Parameter>
    <Parameter Name="EPM_NUMERIC_DATATYPE_0">number(%d)</Parameter>
    <Parameter Name="EPM_NUMERIC_DATATYPE_1">decimal(%d)</Parameter>
    <Parameter Name="EPM_KEY_LENGTH_OPTION">N</Parameter>
    <Parameter Name="EPM_PARTITION_OPTION">Y</Parameter>
    <Parameter Name="EPM_TABLESPACE_OPTION">Y</Parameter>
    <Parameter Name="EPM_TABLESPACE_TAG">tablespace</Parameter>
</Configuration>

As you can see date is already in DD-MM-YYYY format.

Thanks,

Ilovebo (BOB member since 2006-10-17)

system · August 24, 2009, 12:56pm

Navigate to registry (RUN --> Regedit -->HKEY_USERS )

If you look in HKEY_USERS > you see a list of all the account IDs on the computer.

search for sShortDate in the registry, you will find all the appropriate settings and can replace the MM/dd/yyyy values with your preferred format.

Reboot to get it to take effect.

krishnak (BOB member since 2008-06-27)

system · August 24, 2009, 1:06pm

Krish,

Checked the sShortDate in registry. It is in DD/MM/yyyy format already.

Any other idea?

Ilovebo (BOB member since 2006-10-17)

system · August 25, 2009, 4:01am

Can you please change the tomcat web server settings time and date format settings.

krishnak (BOB member since 2008-06-27)