Comparing two date fields and issue a text dependent on the result

[Marc Dahinden]

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