Hi,
I have attached a LOV with a date field, I dont want to display time component in the LOV, so I have selected the object properties, in that “Properties tab” and click on EDIT in 'Associate LOV" block.
It opened a Query panel, I clicked SQL, write
to_date(to_char(datefld,‘dd/mm/yyyy’),‘dd/mm/yyyy’) and checks on “Do not generate SQL …”.
after saving it and clicking on Display (and refreshing the list), it shows the date LOV as dd/mm/yyyy 12:00:00 PM, Please suggest how to hide that time stamp.
trupti 
(BOB member since 2003-06-23)
(BOB member since 2002-06-20)