Null Date Field

[Khushalay]

Hi friends

Im working on a query that returns the date field records excluding null that is if the said date field is null, query wont extract that record in the report.

Im using <>"" and Not IsNull() but both are not working. The type mismatch error comes whereas <>"" works in other text fields and check boxes. Maybe this expression is not used with the date field.

Can I please get some suggestions?

Thanks in advance.

 

[Ranman256]

You don't use the function IsNull(),
You only need:

Not is null

 

[jdraw]

You might also consider the IsDate() function.

 

[Khushalay]

That worked. thanks