Blank Date Field

[Joel]

Hi,

How do you determine if a Date field is blank. In my Sql statement I
only want records who's date field is blank (i.e. checking for only open
invoices where Date_Paid = '' ...still open ...it doesn't work when I use
that syntax)

Thank you

[Gordon Burditt]

Re: Blank Date Field

> How do you determine if a Date field is blank. In my Sql statement I[color=blue]
>only want records who's date field is blank (i.e. checking for only open
>invoices where Date_Paid = '' ...still open ...it doesn't work when I use
>that syntax)[/color]

There's no such thing as "blank" for a date field. You can use
where Date_Paid is null
if the field you're calling "blank" is really null, and it probably is.

Gordon L. Burditt