Convert timestamp to webi date

[system]

Hi,

Please follow the below link:

120×120 10.4 KB

Group, I know this is a real simple one, but I’m all twisted around trying to get this thing worked out . Here is what I got: Oracle 8.17 BO 5.14 I have a LOV for a Date Dimension Object in a Universe called FULL_DATE. I need to have this Date Object show 10/24/2002 or ‘MM/DD/YYYY’ when the user is prompted in a report. However, the prompt LOV shows 10/24/2002 12:00:00AM. I need to supress the Time stamp part of the date that the LOV brings in from the Oracle Table. I’ve trie…

Regards,
Saurabh Gupta

---

saurabhg (BOB member since 2007-04-02)