how to use date criteria in advance search

[amit]

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]

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.

[amit]

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]

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.