Calling MSProjectApplication.DateDifference from C#

Question

0.00/5 (No votes)

See more:

Hi,

I try to call MSProjectApplication.DateDifference from a C# application. The version of MSProject is 2003, and I'm using Visual Studio 2010, running on Windows 7.

private Project.Application m_pr;

....

Project.Task oldTask;
Project.Task newTask;

....

int duration;
duration = m_pr.DateDifference(newTask.Start, oldTask.Finish);

The code compiles without any errors or warnings. However, when I run it I get a System.NotImplementedException when it tries to call the DateDifference function. Any other MSProject related function call that I used in the code works fine; Calling DateDifference directly from MSProject (as VBA macro) also works. I'm unsure whether this function really has not been implemented, or whether I'm doing something wrong.

As a workaround, I currently create a new task in MSProject with the two dates fixed, and read the duration, but that seems not to be a very elegant solution. Any other ideas?

Regards,

Andreas

Posted 1-Feb-12 20:40pm

hal64

Updated 2-Feb-12 15:01pm

Rajesh Anuhya

v3

Add a Solution

Comments

Rajesh Anuhya 2-Feb-12 20:58pm

Edited: Code Tags added
--RA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AlbertoLeon CSharpMan · Answer 1 · 2012-02-02T12:08:00

Solution 1

if start and finish are objects of type DateTime
if newTask.Start is greater than oldTask.Finish

C#

int duration = newTask.Start.Subtract(oldTask.Finish).Days;

Posted 2-Feb-12 12:08pm

AlbertoLeon CSharpMan

Updated 2-Feb-12 12:09pm

v2

Comments

hal64 3-Feb-12 3:46am

Hi,

thanx, but that doesn't work - at least not as required. The duration above gives the total number of days between the two dates. What I need is the number of working days according to the basecalendar in MSProject.

Regards,

Andreas