Hi,
when I try to select with a numeric or character comparison in the where-part, it functions OK.
But how can I use a time/date comparison in the where-part?
I use this query and put it in the sourceproperty of an ADO command object:
SELECT N_ID,C_NAME,C_PLATE,D_STARTDATE, .... FROM database WHERE D_STARTDATE = CTOD('09-09-2001')
I understand that the CTOD command doesn't exist where (in ADO) the query runs, but I really need to select by date...

TIA ET