Number of days between two dates excluding weekends

Here’s the code that can be used within a custom function to find the number of days between two dates excluding weekends.

It uses Data Services’s built-in-function day_in_week().

$l_Start and $l_End are the two input dates ; $l_last_weekday_7 and $l_last_weekday_6  are of type DATE  ; $l_workdays  is INT

$l_last_weekday_7 = $l_start + ((7 - day_in_week($l_start))%7);
$l_last_weekday_6 = $l_end + ((-1 * (day_in_week($l_end) + 1))%7);
$l_workdays= ((($l_last_weekday_6 - $l_last_weekday_7) + 1) / 7) * 5;
$l_workdays= decode ( ($l_last_weekday_7 <>  $l_start) , $l_workdays+ (6 - day_in_week($l_start)),0);
$l_workdays = decode ( ($l_last_weekday_6 <> $l_end ) and (day_in_week($l_end) <6) , $l_workdays+ day_in_week($l_end) , $l_workdays);
print ($l_workdays);