How do I programmatically extract the number of possible Work hours between two dates?

[Guest]

Hello Everyone,

I am writing an aftermarket tool to analyze enterprise resource allocation.

I need to programmatically extract the number of possible Work hours between
two dates as defined by the project server's standard calendar.

My preference would be to extract this information directly from the SQL
database, if necessary using a stored procedure.

If anyone has any ideas about how this might be done, I would be grateful for
the pointer.

Bob

 

[Rod Gill]

Hi,

Have you read the PJSVRDB.HTM file that's installed in one of Project's
program folders? It describes the calendar tables in Project Server

 

[Guest]

Hello Rod,

Yes, I am familiar with both of the PJSRVDB and PJDB references. Both are
excellent
and I have used them on many occasions.

In this case, they do not have much to offer.

What I need to find out is the total number of working days between two
arbitrary dates in the standard calendar.

Do you know enough about how the calendar data is structured to point me in
right drection?

Bob

 

[Rod Gill]

Hi,

I thought from the htm file you calculate the number of days from the
calendar, then subtract any exceptions. From the database you have to do a
lot of cycling through each individual date to get the result. Using
Automation there are built in functions to do it in one go.

 

[Gary L. Chefetz [MVP]]

Bob:

You need to use the Project API to read the calendar data. This data is not
exposed in the database.