>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)]