due date within next 14d query

[Szymon Pochopien]

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

[Charlie Misonne]

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

Or is it not giving the expected results?

[Szymon Pochopien]

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?