>Hi All,
>
>Haven't found any documentation on this but the api is intuitive enough.
>
>I am using the activeX control (olecontrol) from dbi to display data in a grid. Trouble is geting to sort date columns correctly as dates not as char strings.
>
>control.lvAddItem(Str(date - CTOD("01/01/1900")) followed by setting control.lvColumnDataType(column) = 3 does the job. BUT...
>
>It displays the date in the date:time format. Any ideas how to turn off the time part? The user is not interested in seeing that part, only want to see the date.
>
>Thank you
>
>Regards
>
>Mathias
Hi Mathias,
set ControlSource on column to [TTOD(datetimefield)]
ThisForm.Grid1.Column2.ControlSource = [TTOD(datetimefield)]
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
