Can anyone tell my why this code doesn't work? I am using IB_Query
components.

SELECT WORKINGDOCKET.DOCKETID AS WORKDOCKETDOCKETID
, DATEOPENED
, DATECLOSED
, COURTFILENUMBER
, CLIENTTYPE
, COMMENTSLINE
, WTIMEENTRY.DOCKETID AS TIMEENTRYDOCKETID
, WORKTYPE
, TIMEW
, COSTS
, ENTRYDATE
, CONTACTFIRSTNAME
, CONTACTLASTNAME
FROM WORKINGDOCKET INNER JOIN WTIMEENTRY ON WORKINGDOCKET.DOCKETID =
WTIMEENTRY.DOCKETID
INNER JOIN CLIENTS ON CLIENTS.SOCIALSECURITY =
WORKINGDOCKET.SOCIALSECURITY
WHERE WORKINGDOCKET.DATEOPENED BETWEEN :DATE1 AND :DATE2
ORDER BY WORKINGDOCKET.DOCKETID, WTIMEENTRY.ENTRYDATE

Its definitely this line WHERE WORKINGDOCKET.DATEOPENED BETWEEN :DATE1
AND :DATE2

that causes the trouble, and I assume its because the date1 and date2
parameters are not specifically defined as timestamps - but I cant
find anywhere to do that. I know when I was using ADO the parameter
type had to be specified as datetime for it to work.

Thanks,

Jason S. Gagnon