Prompts using DATEs

[system]

Hi,

I have a prompts which is for accepting the date from the user. I have a list of values attached to this. The list of values ranges for sysdate -31 to sysdate -1.

Right now, in the prompt, values are listing with DATE and TIME in below format

MM/DD/YYYY HH24:MI:SS

User wants to see only the date part. i.e MM/DD/YYYY.

I tried to set the format in the universe level and also in the SQL of LOV. Nothing seems to work.

Can you please help ?

Thanks & regards
Vijay

---

vijayhai (BOB member since 2008-12-24)

[system]

Hi,

This has been discussed many many times before.

Check for instance these older posts:

remoe the timestamp from the date

hi i have a weekly report where the records are displayed within the date range entered by the user. Below is the start_date object with the following definition. next_day(@Prompt(‘Please Enter the Start Date’,‘D’,mono,free),‘Monday’)-7 here when the user selects the date from the calender i see the timestamp also gets appended to the date as shown below. next_day(‘05-08-2008 00:00:00’,‘Monday’)-7 I want to remove this timestamp. Should i have to modify the object definition. I tried with …

how to change the date format for LOV

Hi I have an object called sale_date which have the LOV in the below format m/dd/yyyy 12:00:00 AM. I want to remove the timestamp from above format LOV should display the date in “m/d/yyyy” please help me in fixing the problem. Thanks MMVBOB (BOB member since 2008-02-04)

Or use search to find more posts that discuss the same.

---

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