due date within next 14d query

Szymon Pochopien June 21, 2022



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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 21, 2022

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

Or is it not giving the expected results?

Szymon Pochopien June 21, 2022

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