index > Team Foundation Server - Work Item Tracking > Query Date-Time granularity

Query Date-Time granularity

Hi,
if you need a Query that gives you all the changed workItems since yesterday, it's pretty straightforward:

AND Changed Date > @Today - 1

But what if I want finer grain, like all the changes the last 6 hours? Beats me.

Any suggestions?

thanks,
/Tomas

Tomas L

The query builder in UI actually works with dayprecision set, which means it takes time based on operator and this is how mostly users expect to work. So time cannot be specified in UI, but if you use object model you can override this by specifying dayprecision parameter in Query object constructor.

http://blogs.msdn.com/narend

Naren Datha - MSFT

reply 2

You can use google to search for other answers

More Articles

·webservice subscription: URL authorization failed for the request

·Areas and Interations

·Problem logging in Team Foundation Server using ASP.NET

·TF80071 connecting MPP to Team project

·Customize Work Item to block few groups from being seen on some f...

·Developer Hour Tracking Via TFS Add-On

·Problem with displaying "Work Items" for a <PROJECT&...

·Requirement Review and Review Signing(authentication)

·How do you suppress work item creation on build failure?

·Assign Work Item on Check-Out

Welcome to Bokebb New Update Joins the collection

New Articles

·Localized web server instance not launch��
·Problem with Workitem access control - d��
·Work Item Update Collisions
·Is it possible to prevent check-in if a ��
·Adding Areas and Iterations via the obje��
·Work Item Add/Updates Not In Reports
·create WI custom field dependencies
·Missing "Add Work Item" from &��
·How do you suppress work item creation o��
·Nested WHEN or conditional operators
·how to query work items using wild cards
·Attach a note to a work item
·Description query fails when trying to r��
·Using Microsoft Project with TFS Work It��
·MS Project synchronization

Hot Articles

·Problem with MS Project plugin
·End Date for Iterations
·Rules with multi-level picklist.
·Relation between Work Items -> Change��
·How The TFS publish the build numbers us��
·Work item Action list
·Bugs and related work item resolution...
·Work Items created in VS 2005 do not ape��
·MS Project/TFS work items won't move whe��
·missing Microsoft.TeamFoundation.WorkIte��
·Comparing fields of a Work Item when fil��
·Credentials of the SubscribeEvent WebSer��
·Query for attachments
·Notification - Closed task
·Customized Fields on WorkItemChangeEvent

Recommend Articles

·Delete workitem CMMI Project
·Linked Item Columns
·Assign Work Item on Check-Out
·How to delete previously imported items ��
·TF54000: Cannot update data because the ��
·How to make a Dropdown list containing b��
·Handling simultaneously WorkItemChanged ��
·File Attachment Best Practice
·Uninstall TS Plugin
·limit control type links control to spec��
·Automatically generate a work item on st��
·webservice subscription: URL authorizati��
·WorkItemStore null reference
·Assigned To getting blanked out when clo��
·Work Item List Box Cotrols