Date Functions

[External Update]

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

 

[Barbara Henhapl]

Hi,
use 'd' for days. Hope that helps?
Regards
Barbara

 

[Andrew Lavinsky]

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

 

[Dale Howard [MVP]]

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.