Another if statement problem

[twychopen22]

I just need to know how to compare 2 dates in an if statement:
IIF (LastActivation) >= (Date()), (DueToday)= "Yes", (DueToday) = "No"

 

[KenHigg]

If you do it at the query level:

MYDueDate: IIF([LastActivation] >= Date(), "Yes", "No")

???

 

[twychopen22]

Sorry, I don't know how I posted the same question 2x's but the other post has more to say about this. I tried that and it does not work for reasons in the other post. Maybe a moderator could delete this duplicate thread