Date

[Former Member]

I have a date prompt where the LOV consist of date and time (31/08/2011 00:00:00).

How do I make it shows only date (31/08/2011)?

In the database, my date value is only date (31/08/2011).

I am running on server, and the server regional setting is dd/mm/yyyy.

In Webi's preference, under Locales and Time Zone, I set current time zone to "Local to web server".

Thanks.

[Former Member]

Hi,

Just give the below formula to the column of date data,

=ToDate([Calendar Date];"dd/mm/yyyy")

or

Just right click the column of date data and click properties and then choose the date format,

Then choose the format you want eg:DD/MM/YYYY.

I hope this will help to u.

Regards,

Ragoth.C

[Former Member]

Open the universe on which this report is based on.

Select that "Date Object", Go to "Object Properties" --> Click on "Advanced" tab

You will find the a section "Database Format" provide dd/mm/yyyy here.

Test the report again.

Thanks,

Vivek

[Former Member]

Hi Vivek

Tried already. still shows the same result. BTW, I am usign BO4.

Thanks.

[Former Member]

What is the DB you are using?

Can you check which PRM file is used by the universe.

Thanks,

Vivek