Delphi 7 :: TADO Dataset Filter Property :: Cast DateTime  Field to Date

Hi Experts,

I am using a TADOTable component.
In my database table I have a TDateTime field.

My idea is to filter all rows for a given date range by using the Filter property.
How would the syntax look for this as I would firstly need to cast the TDateTime field to TDate and then
specify the ranges.

In SQL it would have looked something like this:

SELECT * FROM TABLE1
WHERE
CAST(FLOOR(CAST(DateTimeFiled AS FLOAT)) AS DATETIME) > :DATE1
AND
CAST(FLOOR(CAST(DateTimeFiled AS FLOAT)) AS DATETIME) < :DATE2

Thanks!Start Free Trial