Hey Gang,
I have a problem that I can't figure out. I'm having a hard time finding the number of minutes between 2 date-times not counting the weekends. My formula is not removing the weekends from the results.
Thoughts?

DateTimeVar d1 := CDateTime(Date({Asgnmnt.DateAssign}),Time({Asgnmnt.TimeAssign}));
DateTimeVar d2 := {@date and time resolved};
DateDiff ("n", d1, d2) - DateDiff ("ww", d1, d2, crSaturday) - DateDiff ("ww", d1, d2, crSunday)

Edited by ravenous - 10 Dec 2014 at 10:39am