DATEDIFF but don't count sat/sun

Muiter · #1 (**permalink**) 01-20-09, 16:21

The code below works perfect but I only want to count the working days, so nu saturday and sunday. Any ideas how to do this?

Code:

<?php
DATEDIFF(IFNULL(lp0.datum_betaald,NOW()),lp0.datum_te_betalen) 
  AS 
  aantal_dagen
?>

I did find DateDiff That Only Counts Working Days but now we are 6 years later so there might an good solution right now.

guelphdad · #2 (**permalink**) 01-20-09, 22:10

this solution looks simple enough.