Wednesday, August 08, 2012 8:13 PM
I need to add the creation date to a report that I'm generating with VS 2010 / C#. I query the project collections, then projects for the names of the projects.
What code would I use to get the 'date created' on a given project?
Friday, August 10, 2012 7:13 AMModerator
Thanks for your post!
Do you want to query the creation date of a team project? If yes, please perform the following SQL query:
SELECT [project_name],[last_update] FROM [Tfs_DefaultCollection].[dbo].[tbl_projects]
WHERE [project_name]= 'ProjectName'
TFS store Date Time as the UTC time in DB. TFS Server can works across the regions, the UTC time as the standard time for different areas. You should covert the UTC time back to the local time in your report code. Pleaser refer to this blog for it:
Hope it helps!
Cathy Kong [MSFT]
MSDN Community Support | Feedback to us
- Edited by Cathy KongMicrosoft Contingent Staff, Moderator Friday, August 10, 2012 7:14 AM
Friday, August 17, 2012 9:09 PM
What additional code is needed to connect to the DB? I haven't used this before. Does this require LINQ or a DataReader?
Sunday, August 19, 2012 2:50 PMWould this be easier to do by querying the WorkItems for the first item in a project's history?