Page 1 of 1

Workdays Calculation - omit Saturday, Sunday

Posted: Mon Oct 12, 2020 4:34 pm
by JHenn
Can anyone recommend a method to calculate, not just a Datediff value, but a difference between two dates that considers only Monday through Friday (omitting Saturday and Sunday)? Any direction would be much appreciated.

Re: Workdays Calculation - omit Saturday, Sunday

Posted: Wed Oct 14, 2020 1:14 pm
by HighAley
Hello,

Sorry, there is no such method in our tool.
But you could add your own custom function.
https://www.stimulsoft.com/en/documenta ... ctions.htm

Thank you.

Re: Workdays Calculation - omit Saturday, Sunday

Posted: Wed Oct 14, 2020 2:56 pm
by JHenn
Thank you, HighAley. Unfortunately, we do not have the means to create functions in our end-user interface. Instead, I modified some C# scripting I found from various sources and added that as a BeforePrint event to populate a variable with the BusinessDays figure. That's not user-friendly but it seems to have achieved the result.

Re: Workdays Calculation - omit Saturday, Sunday

Posted: Thu Oct 15, 2020 10:04 pm
by Lech Kulikowski
Hello,

Thank you for the information.