Hi all…
I have a Date Object in Designer when I see the list of values for that object I see the time stamp attached to the Date…
Is there any work around to remove that time stamp from the object’s LOV
any inputs will be really helpful
kris
krishna 
(BOB member since 2003-08-05)
Please do a search, or read the Designer FAQ, as this question has been discussed many times.
Designer FAQ Entry for Time on Date LOV Queries
Dave Rathbun 
(BOB member since 2002-06-06)
Hi
thanks for the reply
Iam Using SQL Server…
But the One You redirected me is with Oracle
krishna (BOB member since 2003-08-05)
The same concepts apply. 
Dave Rathbun (BOB member since 2002-06-06)
If you are on SQL Server then it shouldn’t be a problem at all. Just Convert the Date Datatype to Character and the Sort Sequence works correctly without any tinkering.
Sri
Sridharan (BOB member since 2002-11-08)
hi,
You create another object and apply dataformat
using(in SQL Server Case is use for format mask)
Regards
hassan 
(BOB member since 2003-08-01)