Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

working days between dates

aurel82's profile image aurel82 posted 3 weeks ago in Creating a connection Permalink

Which function can calculate working days between dates. It is impossible to develop an algorithm. I have no idea how to do this.

ansgar's profile image ansgar posted 3 weeks ago Permalink

DATEDIFF calculates days between two dates:

SELECT DATEDIFF(NOW(), '2019-01-01');

But you want working days?

aurel82's profile image aurel82 posted 3 weeks ago Permalink

I study and I received the task in Heidsql, the information is little, and it is very difficult to fulfill it. From January 1 to calculate all working days, or to put the date of May 5, 2020 and to give the order to find out what the date will be if we choose 23 working days.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
aurel82's profile image aurel82 posted 3 weeks ago Permalink

I study and I received the task in Heidsql, the information is little, and it is very difficult to fulfill it. From January 1 to calculate all working days, or to put the date of May 5, 2020 and to give the order to find out what the date will be if we choose 23 working days.

aurel82's profile image aurel82 posted 3 weeks ago Permalink

any date set to calculate the number of working days, we receive the result 282, the calculation is made only from 01.01.20 until today

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.