It's all about the answers!

Ask a question

How can I create a query that lists all work items when Date 1 is exceeded by Date 2?


bradley ebert (133) | asked Feb 25 '13, 3:16 p.m.
I am trying to create a query that returns all work items where the due date is greater than the replan date. In this case, the due date is just sometime in the future and so is the replan date.  So I need a query that says:

Current user and due date>replan date.  When I choose due date or replan date in the query builder, it is only making a decision on the date, I need a relative comparison between the two dates.

any thoughts on this would be helpful

One answer



permanent link
sam detweiler (12.4k6173200) | answered Feb 25 '13, 8:58 p.m.
I do no believe you can do that with the Query editor.

You will have to use reporting. or write code to build the query dynamically

Your answer


Register or to post your answer.