E
Eddiea
New user here. I want to calculate a custom duration.
I have the following custon columns duration1, start1, and finish1
I want to have duration be the duration between the dates start1 and finish 1
I have used the formular for duration 1 to be
DateDiff("d",[Start1],[Finish1])
But i get
#ERROR NA NA
#ERROR Sat 4/29/06 Thu 5/4/06
What am I doing wrong.
Also I'm not sure what the interval value should be or where it is explained.
Thanks
Eddie A
I have the following custon columns duration1, start1, and finish1
I want to have duration be the duration between the dates start1 and finish 1
I have used the formular for duration 1 to be
DateDiff("d",[Start1],[Finish1])
But i get
#ERROR NA NA
#ERROR Sat 4/29/06 Thu 5/4/06
What am I doing wrong.
Also I'm not sure what the interval value should be or where it is explained.
Thanks
Eddie A