Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,522
Community Members
 
Community Events
165
Community Groups

due date within next 14d query

Hi 

 

Just wondering if I need to review all tickets where the due date is within the next 14 days. I shall duedate > now() AND duedate < 14d to avoid having tickets from the past or just duedate < 14d, Is anyone keen to advise? Thanks

1 answer

1 vote
Charlie Misonne Community Leader Jun 21, 2022

duedate > now() AND duedate < 14d should be correct.

Or is it not giving the expected results?

It is actually, however just checking if this is practical for tickets due within the next 2 weeks.  Wondering if I need to use this duedate > now always when looking future or past?

Will this shows all issues resolved in the last 5 days?

- duedate < now() And resolved > startOfDay("-5")

this duedate < now() - should I treat it a s fullstop for the time management between past and future?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

192 views 0 5
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you