I'd like to compare dates and if one is bigger input a new field value.
I've tried using the rule engine but no win.
DATE1 | DATE2 |
10-03-1990 | 11-03-1992 |
10-04-1993 | 10-03-1993 |
IF DATE1 < DATE 2 THEN *CREATEDFIELD* = "True"
I'd like to compare dates and if one is bigger input a new field value.
I've tried using the rule engine but no win.
DATE1 | DATE2 |
10-03-1990 | 11-03-1992 |
10-04-1993 | 10-03-1993 |
IF DATE1 < DATE 2 THEN *CREATEDFIELD* = "True"
You need to use first the time difference node and than you can apply the rule engine on the difference.
Cheers, Iris