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.