Filtering on Date Fields

Steve Cooper

Delphi Developer

Tue, 12 Oct 2004 05:28:29 GMT

Filtering on Date Fields

I am trying to use the Filter property of a TTable on a date field to
find records that do not have a value in the date field. I have tried
various methods w/o success. I can filter on string fields fine. Does
anyone have a way to do this? Could a Range do this?

Thanks.

Steve
scoo...@kustomsignals.com

Brian Bushay Team

Delphi Developer

Tue, 12 Oct 2004 10:10:33 GMT

Re:Filtering on Date Fields

Quote

>I am trying to use the Filter property of a TTable on a date field to
>find records that do not have a value in the date field. I have tried
>various methods w/o success. I can filter on string fields fine. Does
>anyone have a way to do this? Could a Range do this?

Table1.Filter = 'YourDateField Is Null'

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. How to Filter a date field when it is null

2. Filter using date field

3. Filter on date field

4. Filtering in Date field

5. Filtering on Date field

6. Filter with date fields - Delphi V3 Pro / Paradox

7. How can I specify the Dataset.Filter with DATE field ?

8. How to Filter on a Date field??

9. Problems with filter expression and date fields in Delphi 5

10. Filtering out records with empty date field