You don’t need to count every day in the month. You already know the first 28 days contain 20 weekdays no matter what. All you have to do is determine the last few days. Change the start value to 29. Then add 20 weekdays to your return value. function get_weekdays($m,$y) { $lastday = date(“t”,mktime(0,0,0,$m,1,$y)); $weekdays=0; … Read more
Simply try it using a simple function : CREATE FUNCTION TOTAL_WEEKDAYS(date1 DATE, date2 DATE) RETURNS INT RETURN ABS(DATEDIFF(date2, date1)) + 1 – ABS(DATEDIFF(ADDDATE(date2, INTERVAL 1 – DAYOFWEEK(date2) DAY), ADDDATE(date1, INTERVAL 1 – DAYOFWEEK(date1) DAY))) / 7 * 2 – (DAYOFWEEK(IF(date1 < date2, date1, date2)) = 1) – (DAYOFWEEK(IF(date1 > date2, date1, date2)) = 7); Test … Read more
Here is a rough version with comments describing the steps: // create a Calendar for the 1st of the required month int year = 2010; int month = Calendar.JANUARY; Calendar cal = new GregorianCalendar(year, month, 1); do { // get the day of the week for the current day int day = cal.get(Calendar.DAY_OF_WEEK); // check … Read more
When dealing with day-of-week calculations, it’s important to take account of the current DATEFIRST settings. This query will always correctly exclude weekend days, using @@DATEFIRST to account for any possible setting for the first day of the week. SELECT * FROM your_table WHERE ((DATEPART(dw, date_created) + @@DATEFIRST) % 7) NOT IN (0, 1)