US date format

[Former Member]

Any report that I create in desktop intelligence has a US date format mm/dd/yyyy. Even if I set a Condition in the report query panel, if the condition is a date and I set a value for the date, this is shown in US format in the Conditions panel.

Help pls.

[Former Member · Accepted solution]

Hi Louise,

When displaying a List of Values based on Date/Time, the date is displayed in US English format (mm/dd/yyyy). This is because the date format depends on the installation language, not on the locale set in the regional settings of the system on which the server resides.

If the installation language was defined as US English, the format for date time objects will be in US English.

To change the Format of LOVu2019s to DD/mm/yyyy format do the Following changes to the Registry.

Modify the locale when re-running the setup

or

Manually edit the registry:

1. Click Start > Run. The Run dialog box appears.

2. Type regedit in the Open field. Click OK. The Registry Editor appears

3. Navigate to HKEY_LOCAL_MACHINE/Software/Business Objects/Suite 11.5/default/Shared/General/Setup/Languages/Available/EN

4. Edit the BOShortName key value to EN

5. Edit the Country key value to GB

6. Close the Registry Editor

Close All Applications like Designer, Desktop Intelligence and open again for the changes to take effect you can see the LOVu2019s of dates changed to dd/mm/yyyy format.

I hope this Helpsu2026

Thanksu2026.

Pratik

[Former Member · Accepted solution]

Thanks very much, that sorted the outstanding issues.