help with date-based calculations -- again
Posted by keke on September 04, 2001 2:53 PM
Back in mid-August, Aladin helped me come up with a formula to take a due date and a finished date and compare them, returning a negative number if the job was finished before the due date.
My message to Aladin said:
I found I had to make one minor change to the formula since it said I had too many arguments. So what I ended up with was:
data'!H6-'Workflow data'!P6)),'Workflow data'!H6-'Workflow data'!P6)
Well, it SEEMED to work. Turns out it is fine if the number to be returned is negative. If we miss our due date (due date - delivery date = 1 or more) it
returns a FALSE value rather than the number. Could it be that "too many argumants" thing I deleted?