Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Project start date RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Projectstartdate field of MSP_epmproject_userview  gives me the date which we created the project , if we change the project start date in schedule page then also it reflects project creation date.

    Can any body let me know if project start is different than the  project creation date in project server than how we should pick that for our reporting purpose/ and logic building.

    Thanks

    Vinay

     

     

     

    Vinay Gupta
    Thursday, August 11, 2011 8:49 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Vinay,

    Yes those dates are different. the creation date is for administration only. The real project start (and end) dates can be retrieved from the summary task.

    SELECT 
   [TaskStartDate]
   ,[TaskFinishDate]
 FROM [ProjectServer_Reporting].[dbo].[MSP_EpmTask]
 WHERE 
   [TaskOutlineLevel] = 0 
  AND 
   [ProjectUID]='<your project UID>'

    Regards, J
    • Proposed as answer by Peter Farkas Thursday, August 11, 2011 2:31 PM
    • Marked as answer by Kvingupta Friday, August 12, 2011 12:50 PM
    Thursday, August 11, 2011 9:51 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Vinay,

    Yes those dates are different. the creation date is for administration only. The real project start (and end) dates can be retrieved from the summary task.

    SELECT 
   [TaskStartDate]
   ,[TaskFinishDate]
 FROM [ProjectServer_Reporting].[dbo].[MSP_EpmTask]
 WHERE 
   [TaskOutlineLevel] = 0 
  AND 
   [ProjectUID]='<your project UID>'

    Regards, J
    • Proposed as answer by Peter Farkas Thursday, August 11, 2011 2:31 PM
    • Marked as answer by Kvingupta Friday, August 12, 2011 12:50 PM
    Thursday, August 11, 2011 9:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Jeroen , this is exactly what I wanted.

    I appreciate the way you reverted and gave  this query.

    Thanks

    Vinay

    Vinay Gupta
    Friday, August 12, 2011 12:53 PM