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".