Prev: show task notes as either a report or in outlook calender
Next: Highligt a Date in Project 2003?
From: External Update on 17 May 2010 10:45
I am having problems getting the syntax correct for the DateDiff function.
Help states that it's DateDiff (interval,date1,date2). If I want the
resulting interval in days, what do I enter?

Thanks
From: Barbara Henhapl on 17 May 2010 11:05
Hi,
use 'd' for days. Hope that helps?
Regards
Barbara

"External Update" <ExternalUpdate(a)discussions.microsoft.com> schrieb im
Newsbeitrag news:2BF18F0F-589C-4502-83D1-D18AC40AE47B(a)microsoft.com...
>I am having problems getting the syntax correct for the DateDiff function.
> Help states that it's DateDiff (interval,date1,date2). If I want the
> resulting interval in days, what do I enter?
>
> Thanks

From: Andrew Lavinsky on 17 May 2010 11:15
You could also try the following syntax:

ProjDateDiff([Date1],[Date2])

....and make sure you're using a Duration field, not a number field. If you
use a number field, you'll have to divide by [minutes per day]


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

> Hi,
> use 'd' for days. Hope that helps?
> Regards
> Barbara
> "External Update" <ExternalUpdate(a)discussions.microsoft.com> schrieb
> im Newsbeitrag
> news:2BF18F0F-589C-4502-83D1-D18AC40AE47B(a)microsoft.com...
>
>> I am having problems getting the syntax correct for the DateDiff
>> function. Help states that it's DateDiff (interval,date1,date2). If I
>> want the resulting interval in days, what do I enter?
>>
>> Thanks
>>



From: Dale Howard [MVP] on 17 May 2010 11:53
External Update --

To add to the excellent answers given already by several other users, I
personally like the ProjDateDiff function, as it allows you to specify which
calendar to use to calculate the date difference. Remember to use a custom
Duration field, such as the Duration1 field, with a formula that utilizes
the ProjDateDiff function. Hope this helps.

--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"External Update" <ExternalUpdate(a)discussions.microsoft.com> wrote in
message news:2BF18F0F-589C-4502-83D1-D18AC40AE47B(a)microsoft.com...
> I am having problems getting the syntax correct for the DateDiff function.
> Help states that it's DateDiff (interval,date1,date2). If I want the
> resulting interval in days, what do I enter?
>
> Thanks

 | 
Pages: 1
Prev: show task notes as either a report or in outlook calender
Next: Highligt a Date in Project 2003?