Board index » delphi » Filtering for Null Date

Filtering for Null Date

I'm trying to setup a filter to look for records with no date in a date
field.  How do I define the filter?

Thanks
Colin

 

Re:Filtering for Null Date


Quote
> I'm trying to setup a filter to look for records with no date in a date
> field.  How do I define the filter?

Table1.Filter := 'DateFieldName = Null';

--
David Reed
Diamond Software Group, Inc
www.diamondsg.com

Re:Filtering for Null Date


If there is no date-value added, the field is set to 0.

Table1.Filter := 'DateFieldName = 0'

John Kuiper

Quote
Colin Aiken wrote:
> I'm trying to setup a filter to look for records with no date in a date
> field.  How do I define the filter?

> Thanks
> Colin

--
************** THE NEW DIMENSION IN DISTRIBUTION *****************
  ilion Faculty B.V.
  John Kuiper                        email: jo...@ilion.nl
  Randstad 21-57                       tel: +31 (0) 36 548 50 10
  1314 BH  Almere-Stad                 fax: +31 (0) 36 533 29 78
  The Netherlands                 Helpdesk: +31 (0) 36 548 50 13
*******************  http://www.ilion.nl  ************************

Re:Filtering for Null Date


SQL Try TableFieldname.isnull

--
Don Cooper
Skyline Technologies
skyli...@ozemail.com.au

Quote
John Kuiper wrote in message <382C3874.C0014...@ilion.nl>...
>If there is no date-value added, the field is set to 0.

>Table1.Filter := 'DateFieldName = 0'

>John Kuiper

>Colin Aiken wrote:

>> I'm trying to setup a filter to look for records with no date in a date
>> field.  How do I define the filter?

>> Thanks
>> Colin

>--
>************** THE NEW DIMENSION IN DISTRIBUTION *****************
>  ilion Faculty B.V.
>  John Kuiper                        email: jo...@ilion.nl
>  Randstad 21-57                       tel: +31 (0) 36 548 50 10
>  1314 BH  Almere-Stad                 fax: +31 (0) 36 533 29 78
>  The Netherlands                 Helpdesk: +31 (0) 36 548 50 13
>*******************  http://www.ilion.nl  ************************

Other Threads