Question Re: US date format in Technology Q&A

US date format

Former Member — Wed, 18 Feb 2009 17:31:32 GMT

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.

Re: US date format

Former Member — Thu, 19 Feb 2009 06:04:13 GMT

Hi Louis,

You can set the date format in the universe by a right click on the object in the universe and then format.There you can change the format of the date as you want.

Hope this would resolve your issue.

Regards

Prashant

Re: US date format

Former Member — Thu, 19 Feb 2009 10:07:56 GMT

Thanks very much for your response. This works nicely in one way, but not in another. This works in displaying data on the report itself, but this doesn't work for example in the Conditions box. Here, if I select a date field formatted as dd/mm/yyyy, and I enter a condition as "xxx Equal to" and type a date e.g. "18/02/2009", this will show as "02/18/2009". Do you know what the problem is here?

Re: US date format

Former Member — Thu, 19 Feb 2009 12:36:20 GMT

Hi Louis,

In the Universe Open the Objects.Copy the Object and paste it in the same class it would be like eg:

Birthday2

Goto Object>Properties>Edit>SQL

try this code

Select To_Char(Birthdate,DD/MM/YY) from Birthday

Click on Do Not Genetate SQL.

OK .

Click on Export with Universe.

Keep this Birthday2 as your filter condition in the Report.

Regards

Prashant

Re: US date format

Former Member — Thu, 19 Feb 2009 14:27:33 GMT

Thanks, but surely there must be some easier way of doing this? Isn't there a server setting somewhere? Surely not everyone who wants the dates in the Conditions displayed differently to US date format have to do this for every date field??

Re: US date format

Former Member — Thu, 19 Feb 2009 16:21:23 GMT

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

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

Re: US date format

Former Member — Thu, 19 Feb 2009 16:34:42 GMT

Thanks very much, that sorted the outstanding issues.