Blank Date Field

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View


    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 doesn't work when I use
that syntax)

        Thank you

Re: Blank Date Field

Quoted text here. Click to load it

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

Site Timeline