Filter by date and time (hour)

[bathiyasri2]

There should be possibility to filter by "changed date and time" in Wiql. Even better if you can this feature in default query section. Basically i want to query work items which changed during last 'x' hours.

in wiql -

System.ChangedDate ='12/07/2018, 6:42:45' or System.ChangedDate =('12/07/2018, 6:42:45')-1hour

[ostreifel]

There is a flag (timePrecision) that I could expose that would allow you to do this in the playground but it would not be work if you tried to save the query or open in it the in product queries menu and so I think making it available in the playground would create more problems than it would solve.

As a workaround you can apply decimal offsets to the @today macro as long as you can express your query in terms of that macro.

Here is an example of that.