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]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

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??