Please make DateDiff Exclude weekends. It can't be done reliably by any coding like mentioned here
We need function or extend datediff function to make it reliable. We also need option in datediff to exclude other days then weekends.
For example if we have app for booking holidays. Each shift works different days. Morning shift monday to friday and night shift monday to thrusday. We need to calculate how many days they booked
The feature would very desireable in calculating vacation days taken.
datediff - weekends - statutory holidays.
ie. taking off July 1, 2019 to July 8, 2019 inclusive (Saturday, July 6, Sunday, July 7, removed, plus Thursday, July 4 removed)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.