Filter date field

[PolarBear]

I have a date field that I need to filter. Individuals are on a committee list that typically has a begin and end date. The end_date field can be populated with a specific end date such as 09/02/2005 or it may be left blank which indicates that it is an open term with no specific end date.

Is it possible to query all indiviiduals who have either an end_date >=09/02/2005 or IsNull (ie the field is empty) which would indicate an open term in the required report.

thanks,

PolarBear

 

[FoFa]

UUM
(End_Date >=09/02/2005 OR End_Date is null) AND Start_Date <= xx/xx/xxxx