Hello
I like to compare due date (duedate) with today's date (now() ) and issue then a text.
with _now = now():
with _duedate = duedate:
IF status = "done":
"done"
ELSE IF _duedate < _now:
"delayed"
ELSE IF _duedate = _now OR _duedate > _now:
"on track"
ELSE: "Maintain due date!"
I assume there is a date format issue because there is always issued "delayed" except there is no due date maintained.
Thanks for your support
Marc