I am running Crystal Report against a SQL sever database and tring to exclude all records in the Select Expert where a date field is null.

However I cannot seem to get the sytax to work correctly, although I can limit the resutset where a date is equal/between/greater than or less than a particular date.

Does anybody know how Crystal Reports interprets null values and what the correct sytax should be.