date problem in prompt

[system]

Hi All,

I have created a prompt which is a date. In its LOV I am getting time also alongwith date but in actual table there is no time. Can anyone tell me how can I modify this so that time does not come in list of values.

---

rittu (BOB member since 2008-11-02)

[system]

The problem was discussed recently here:

LIST OF VALUES -Ricardo-

I have a list of values with a date format field -oracle data base- which is visualized in the format DD/MM/YYYY H:MM:SS I want it to be visualized in format DD/MM/YYYY but I do not Know how to do it. When using “TRUNC” I only get the hours, minutes and seconds to be 0, but I am not able to make them disappear of the list of values. How can I do then?. Thankyou for your time. Ricardo. PRGG1 (BOB member since 2008-09-05)

---

Marek Chladny (BOB member since 2003-11-27)