SQL: The outcome of how DateDiffNoWeekends should work
In a recent post, I discussed questions that had come up about how we should calculate the number of days between two given dates, but excluding the weekends i.e. people just wanted the number of weekdays.
This relates to one of our SDU Tools called DateDiffNoWeekends. Some customers using it felt that it didn’t calculate the days in the way they thought it should. And on reflection, I agreed.
Much of the discussion centred around how we should treat start and end dates, depending upon whether they were on the weekends or not.
2019-02-19