IIf Query with dates

[DelbyJones]

This forum saved my life once before. Here goes one more time.

I have a date field in table. Some entries are blank, others have a date entered. That date is either expired or not. My expiration date is 10/10/2012.



I want a query with a column that returns “no” if the field is either blank OR if the field is before 10/10/2012, and “yes” if it’s 10/10/2012 or after.

I’m having trouble writing an IIf expression for that, I think it's because of the "or" in my criteria. Can someone help me?

[JoeM]

How about this:

Expired: iif(DateValue(nz([MyDate],"1/1/2000"))<datevalue("10/10/2012"),"no","yes")

[DelbyJones]

That worked, Joe. I can stop banging my head on the desk. Can't thank you enough!!!