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)
Right click on the date object and select “Object Format” from the context menu, and select the format you to convert to …
niranjan.bo (BOB member since 2007-03-27)
Hi niranjan,
Actually I tried exactly what you mentioned. I am able to get the format in the report. But my problem is I want change the format in the List of values. I created one report in which I used the sale_date in condition and prompts the user to select the date values. There the problem is . It should display without the timestamp. even i changed the object format still it is not displyed in the list of values.
do you have any other suggestions
Thanks
MMVBOB (BOB member since 2008-02-04)
That’s the way it works. If you want to display a date without a timestamp then you must convert it to something other than a date. Please see this FAQ entry for more details.
Dave Rathbun 
(BOB member since 2002-06-06)
Try this…
Go to Object properties and in second tab you can see “Edit” button which will give you with query pannel. Go to sql and customize the sql using to_char function and check “Do not generate sql”. save and try again… probably this will work.
niranjan.bo (BOB member since 2007-03-27)