I'm trying to get textbox to compare the current date to duedate. I can't get the syntax to work, this is what I have

=IIf([DueDate]>[=Date$()],"OverDue","")

HELP:confused:

teiben,

Try:

=IIf([DueDate] < Date, "OverDue", "")

If DueDate is "before" today, its overdue.

Wayne

I tried that, but it asks for a parameter value for date.

It should be Date() in sql, Date in vba

=IIf([DueDate] < Date(), "OverDue", "")

Finally it works! You ROCK, thank you