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

Marc Dahinden
Contributor
January 12, 2023

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

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events