Category Archives: sql

sql

calculate number of workdays between dates :: ms access sql

I dont like Microsoft access. Sure, its widely used in businesses, but as a database tool, I find it lacking in many ways. However, trying to change non technical employees to work with mysql or something of the sort, would probably present itself with greater issues.

Recently I was asked if I could help create a form that would calculate the number of workdays between two dates. Workdays and weekdays are very different, so its important to recognise the differences.

read more »