I found this in CR help for the "DateDiff" command. It might work for you. I did some tests and this code will correctly count the number of work days if the start date is a Saturday or Sunday. If it is a MTWTF, the count seems to be 1 day off. You might have to add 1 to the formula if the start day is MTWTF. Good Luck.
For example, suppose you want to calculate the number of days between the order date and ship date, excluding Saturdays and Sundays:
Rem Basic syntax
Dim d1, d2
d1 = {Orders.Order Date}
d2 = {Orders.Ship Date}
formula = DateDiff("d", d1, d2) - _
DateDiff("ww", d1, d2, crSaturday) - _
DateDiff("ww", d1, d2, crSunday)
//Crystal syntax
Local DateTimeVar d1 := {Orders.Order Date};
Local DateTimeVar d2 := {Orders.Ship Date};
DateDiff ("d", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday)
Edited by JohnT - 19 Jan 2011 at 9:38am
IP Logged
