Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how do I calculate the diff. between 2 dates and remove the weekends?
hi hilaryb, thank u very much 4 ur quick responding reg. my question. let me tell u that it works perfect. again ... thank u very much :-)) greetz peer -
extracting weekends
hi folks, i need to extract the weekend out of a given timeperiod. does anyone have an idea ho to do that with notes 4.6? greetints from germany peer -
how do I calculate the diff. between 2 dates and remove the weekends?
Hi experts, I calculate the difference between 2 given dates with the following formula: temp := (ITEndtermin-ITStarttermin)/(60*60); tage := @Integer(temp / 24); stunden := @Modulo (temp;24); @If(@IsError(temp); ""; @Text(Tage) + " Tag(e) " + @Text(stunden) + "...
