Retrieving the Status Date

[Dave]

I have a field that I'm calculating the number of days difference
between current date and the the baseline finish date. I realized
that, for my purposes, it would be more accurate to use the Status Date
instead of the current date. Date() gets me the current date, but I
can't figure out how to get the Status Date. Can anyone help? Thanks.

 

[Chak]

Dave,

Run this SQL query on Project Server Database:

SELECT PROJ_NAME as Project, MSP_PROJECTS.PROJ_INFO_STATUS_DATE as
StatusDate From MSP_PROJECTS

 

[Chak]

Dave,

Are you looking for Status date of the project, If so,

Run this SQL query on Project Server Database:

SELECT PROJ_NAME as Project, MSP_PROJECTS.PROJ_INFO_STATUS_DATE as
StatusDate From MSP_PROJECTS

Thanks
Chak

 

[Dale Howard [MVP]]

Dave --

Use the [Status Date] value in your formula. Hope this helps.

 

[Dave]

Thanks Dale. Duh. I thought I had tried [Status Date], but had
acutally type [StatusDate]. Either way, don't understand why Microsoft
doesn't allow you to select it off of the list of date fields in the
drop down list in the Edif Formula window - it would make it easier for
boneheads like me.

 

[Dale Howard [MVP]]

Dave --

You didn't look hard enough, my friend! The [Status Date] field is
located in the Formula dialog by clicking the Field button, selecting
Project, selecting Date, and then selecting Status Date from the flyout
menu. In your defense, it's kind of buried, isn't it? Hope this helps.