how to use date criteria in advance search

Question

Hi Am trying to search the tickets with specific date range.

example, searching for a ticket which has due date winthin next 3 days

or tickets where 3 days are passed after due date.

if I use criteria like "due date" > 3d or "due date" <= 3d // etc.

I do get results but these are not accurate.

I get all tickets having due date in past or in future.

please guide with search criteria.

Jack Brickey · Answer

Resolution is Empty and Duedate >= -3d and duedate <= startOfDay(-1)

If you run the above today (Nov 25th) you should receive issues due on 22nd, 23rd, 24th. Play w/ the numbers to get precisely what you are looking for.

amit_01ybzk · Answer

Thank you for response.

with "-3d" still I get tickets which has due dates in May or April.

I want to search tickets only in last 3 days where I have missed the delivery date.

Jack Brickey · Answer

see what this yields

Resolution is Empty and Duedate >= -3d and duedate <= 3d

note, this assumes you are diligently setting the Resolution when marking issues done.