Tasks with a Due Date of a given day are being marked as Overdue and/or Completed Late when completed on the same calendar day as the due date. This behavior impacts SLA tracking and employee performance metrics.
Is there a way to edit the SLA metric goal settings so that the deadline evaluates against End of Day (23:59:59) instead of the default midnight start of day (00:00:00).
Thank you Varun, this was very helpful, if you don't mind sharing the JQL/smart value pattern with me that would be great.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zara,
The short answer: there's no per-field "evaluate against end of day" setting in native Jira — the behavior you're seeing is baked into how the Due Date field works, worth understanding why.
Due Date is a date-only field (no time-of-day component). Internally Jira anchors it to 00:00:00 on that calendar day. Your Resolved/completion timestamp is a full date+time value. So the comparison is really "exact timestamp vs. midnight at the start of the due date" — any completion after 00:00:00 on the due date itself reads as "after," hence Overdue/Completed Late, even though colloquially the due date hasn't "expired" until 23:59:59. This is documented, consistent behavior, not a bug.
A few things depending on what's actually driving this:
{{issue.duedate}} and {{issue.resolutiondate}} to yyyy-MM-dd and compare those, then set a separate "On time" flag.Worth clarifying which of those applies (plain due date vs. JSM SLA) — the fix path differs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.