Custom Field Calculation HELP!!!

[Michael N.]

I need a field which calcs the difference in days between
two date fields, Finish and Date1 (custom date field).
Tried the DateDiff formula:
DateDiff("hh",[Finish],[Date1])
....I just get #ERROR as a result!
BTW, I'm using a custom Number1 field to run the
calculation.

 

[Michael N.]

Javahound...Thank you very much. Your solution worked
perfectly! Mike

-----Original Message-----
This is a datediff formula that I use to create a variance
from today:

ProjDateDiff([Date2],[Finish])/480

BTW, my date2 field is Now(). I divide by 480 to
get 'days' (8x60).

You will receive #ERROR if one of your fields is blank or
creates a #ERROR situation in itself.

Insert all the columns and try changing a value to see if
it still returns #ERROR.
HTH,
the javahound

-----Original Message-----
I need a field which calcs the difference in days between
two date fields, Finish and Date1 (custom date field).
Tried the DateDiff formula:
DateDiff("hh",[Finish],[Date1])
....I just get #ERROR as a result!
BTW, I'm using a custom Number1 field to run the
calculation.
.

.

 

[Gérard DUCOURET]

Hello Michael,

Your first formula was good too, except one error if you want the number of days between the 2 dates
:
in... DateDiff("hh",[Finish],[Date1])
replace "hh" by "d" for days
....or by "w" for weeks.

Gérard Ducouret