Formula to calculate diff in dates

R

Renee H

I am trying to create a custom field that compares 2 custom dates and tells
me the number of days between the two. I tried the following:
ProjDateDiff([Date 1],[Date 2])/480

and

[Date 2]-[Date 1]

Any suggestions?
 
D

Dale Howard [MVP]

Renee H --

If you create the formula in a Duration field, you don't need to do the
division by 480. Hope this helps.
 
R

Renee H

That did it! Thank you so much!

Dale Howard said:
Renee H --

If you create the formula in a Duration field, you don't need to do the
division by 480. Hope this helps.




Renee H said:
I am trying to create a custom field that compares 2 custom dates and tells
me the number of days between the two. I tried the following:
ProjDateDiff([Date 1],[Date 2])/480

and

[Date 2]-[Date 1]

Any suggestions?
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Renee --

You are more than welcome, my friend! :)




Renee H said:
That did it! Thank you so much!

Dale Howard said:
Renee H --

If you create the formula in a Duration field, you don't need to do the
division by 480. Hope this helps.




Renee H said:
I am trying to create a custom field that compares 2 custom dates and
tells
me the number of days between the two. I tried the following:
ProjDateDiff([Date 1],[Date 2])/480

and

[Date 2]-[Date 1]

Any suggestions?
Click to expand...
Click to expand...
Click to expand...
 
Top