Date Difference -MSPROJECT

[_BLACK]

hi
i would like to get the difference between 2 days (in days )

i tried DateDiff( ) which is giving % result
how can i get ht etotal no: days including saturdays and sundays

Lot's of Thaks

Blake

 

[Peter Hewett]

Hi Blake

The DateDiff Function should do exactly what you want. Modify the following
code:

DateDiff("d","28/1/04","28/2/04")

The above returns 31 (days).

Replace the first date with the variable/property/method that contains your
start date and replace the second date with your end date.

HTH + Cheers - Peter

 

[_BLACK]

hi peter,

i've given the same thing only
i tried it on office 2000 pacakage
but it is returning the result in %.
Do you think some setting is to be changed

Thanks a Lot

Blake

 

[Jonathan West]

Hi Blake,

Show us the exact code you are using at the moment.

 

[Peter Hewett]

Hi Blake

I don't have project by I do have Office 2000/XP. The code should work ok.
Are you incorporating it into a VBA procedure? If not how/where are you
using it? Im not sure what/now you are displaying/outputing the result of
the DateDiff Function. You obviously need to format the output to display
an Integer.

HTH + Cheers - Peter

 

[_BLACK]

hi
my problem is :
In ms project we got a column called Duration where we are getting the
duration between the days (start & end) excluding saturdays and sundays.

now my requirement is to get the whole duration (including sat & sundays)
So i added a new column gave it as of type duration1 and given the formula

DateDiff("d","28/1/04","20/2/04")

but it is giving some number which i found is percentage

Should i change Duration1 type? if yes to what?

i'm not expirenced with msproject

Lots of thaks
Blake

 

[_BLACK]

Code

DateDiff("d",[Start],[Finish])

when i gave start as 1/1/04
and Finish as 1/30/04

THE VALUE IT IS GIVING IS 0.06

Thanks in Advance
Blake