In query check for NO date

[burrina]

What is the correct syntax to check a field for a no date value? That is, if it has no date in it?

Or, how about the syntax in vba to check if dteentered has a date in it or is null or empty or whatever the correct terminology is?


If Me.dteentered IsEmpty
If Is Null dteentered
If IsDate dteentered
???

[June7]

If IsNull(Me.dteentered) Then

or

If Not IsDate(Me.dteentered) Then

[burrina]

Thank You! I am trying to filter out all of the dead data in my table.