Between Dates

Must you take into account bank holidays? That would be difficult, unless they were stored in the database.

How accurate do you need to be? Is just multiplying by 5/7 an option?

Otherwise you would need to calculate how many “whole” weeks are in the period; then modify the result with a long “if” statement, determining whether the period starts on a Monday, Tuesday . . . . and ends on a Monday, Tuesday . . .

Or this might help:


mikeil (BOB member since 2015-02-18)