SQL to select unpopulated date
Posted on 2007-03-31
In my Access 2000 app I need to build a query with a compound condition. The first two conditions are numeric conditions but the last condition is that I want to pull any record that does not have its date field populated.
Here is what I have so far to satidfy my first two conditions. What would I need where I have ??????? for the third condition? The date feild that I want to query is named 'EndStatusDate' and I want the ones that have not been populated.
selectString = "Select EndStatusDate From " & wkTable
whereCond = " Where [DealD] = " & gDealID
whereCond = whereCond & " and [OldStatus] = " & gPriorStatus
whereCond = whereCond & " and [EndStatusDate] = " & ??????????
selectString = selectString & whereCond