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
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?
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.