Trying compare for Previous Date

ab042

I'm trying to set an attribute if the date is already past, the logic doesn't appear to be working. The InvDate is 11/30/2008 and the current date is today. v4.0 / USA date // Any suggestions appreciated.

I have the following rule:
IF Invoice.InvDate < DATE_ADD(CURRENT_DATE,0) THEN
Invoice.InvAccepted='No'
Invoice.InvNote='DATE already past, request REJECTED'

This is the Log View of the rule:
Evaluating condition Invoice.InvDate<DATE_ADD(CURRENT_DATE,0)
Condition evaluated to false: 11/30/2008<(:21/12/2008,0):21/12/2008

Shouldn't this be TRUE??

ab042

My mistake, sorry! Sometimes we can't see the forest for the trees. The "Invoice.InvDate" attribute was Plain Text.

If someone else has this problem. Use the AS_DATE function to convert the plain text to a date.