Home / Announcements / Forums / TFS Work Item Manager and Project Dashboard: TFS Work Item Manager > How to group by Closed Date without time stamp?

• Michael Paterson

  Posted on Dec 2, 2010 (permalink)

  I have a query which groups work items by closed date.  However, the closed date includes a time stamp.  This is throwing off the groupings.  Is there any way to group by closed date without the time stamp?

  Reply

• Ryan Ryan

  Posted on Dec 3, 2010 (permalink)

  Hi Michael Paterson,

  There is no way to get the grouping to ignore the time and only group by day. Perhaps you could sort by this field instead of group by it? If you hold down SHIFT when you click on the grid column header for sorting it will allow you to sort by multiple columns.
  
  Another thing you could do would be to customize your TFS work item template so that the work items do not contain the closed time, or so they have another field that is the date only without the time. But this is a more complex solution.

  Kind regards,
  Ryan
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply


• Ari Perlstein

  Posted on Aug 11, 2011 (permalink)

  If you are using SQL you could just take the date/time you are pulling from the database and strip the time off using a simple SQL command.
  
  

  SELECT DATEADD(dd, DATEDIFF(dd, 0, [date_time_column]), 0) as just_date

  Reply

• Jordan Jordan

  Posted on Aug 17, 2011 (permalink)

  Hello Ari,

  Thanks for the suggestion. Unfortunately we do not use the sql to access the tfs data. We are using the tfs API to load all the data from it.

  All the best,
  Jordan
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply

Back to Top

Home / Announcements / Forums / TFS Work Item Manager and Project Dashboard: TFS Work Item Manager > How to group by Closed Date without time stamp?