Iif and Empty Date Fields

[Deleted member 143240]

Hi All... Working in Access 2010... and 2016 in my work environment. I am trying to figure this one out how to do this with an IIf statement. I don't know how to use VBA, so if that is your solution, it won't work for me...

:banghead:

I have a date field. In the date field, it is either empty or has a date. Basically what I want to do is this:

In a query or report bound report field:

IIF(IsEmpty([DateEntered]),"N","Y")

So, if the field is empty then it returns an N, if it has a date in it, it returns a Y. I can't seem to get the syntax to do this. Any ideas?

 

[jdraw]

Use the IsDate() function.

 

[Deleted member 143240]

OMG! That was so easy.... THANK YOU THANK YOU THANK YOU.... I don't understand why I couldn't find that in any of my searching!