date without time when i selecte the date in the calendar prompt
893673Oct 11 2011 — edited Oct 11 2011Hi, experts!
I just wonder the method to show the date without time expression when i select the date in the calendar prompt.
I used this syntax
'case when 1=0 then cast (DATECOLUMN as date) else date '2011-07-31' end' in the Column formula box and set '2011-07-31' as default value,
and then I can see '2011-07-31' in the box of prompt.
However, when I set another date using calendar control, the selected date is expressed like that '2011-07-28 00:00:00'. I want to show the date without time like this '2011-07-28'.
Please, help me.
Thanks ;)