Due Date filter

[Az]

How can I set a due date for a exact day per week? Right now I can I set it for a set date - e.g. March 1st, or as a relative time e.g. 1 week for now. 

I want to able to see all the issues that are due on the monday coming up. How can I set this in the filter?

[Nic Brough -Adaptavist- · Accepted solution]

A due date is just a date, it has no time component.  You'll need to use a different field - a custom field of type date/time.

[Az]

what do you mean it has no time component?

For example if I set the due date 3/30/18. That is the Friday.

What I want is to be able to create 2 filters that I can put on the dashboard using gadgets. 

One that will show all the tasks that are due by the friday coming up - the tasks for this week

Another that will show all the thtat aer due by the friday after that - the tasks for next week. 

How can I establish this? If by a custom field, then how exactly?

[Nic Brough -Adaptavist-]

No time component means what it says.  There's no time in a due date.  You can say something is due on Monday, but not when on Monday, because there's no time there.  What time of day is it if I say just "12th January 2019"?

Your new requirement is possible though, ignoring the time -

due < endOfWeek()

due > endOfWeek() and due < endOfWeek (+1)

[Az]

Yes, I'm not looking for a specific time on that day. 

Great. I'll try that!

[Marc Isikoff]

Is there a different system date time field we can use? For Service Management it is customary in some orgs to proffer a "soft close" to tickets pending with a customer for a certain time (e.g., > 1 week) and give it a 2-day soft close before it resolves. This can be automated in a two-step fashion:

1) When someone transitions a ticket to "Soft Close" it sets due date to now + 2 business days. This is currently just days (no time on the 2nd business day hence the ask).

2) Each hour we run a check for "Soft Close" with {{now}} > due date and transition those to "Resolved". Obviously we are moving this from hourly to once a day in the meantime to close tickets due on this date. Utilizing a system field with date + time would make this more real world.