Workdays Calculation - omit Saturday, Sunday
Workdays Calculation - omit Saturday, Sunday
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.
Judy Hennessey / PrecisionBI
Re: Workdays Calculation - omit Saturday, Sunday
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.
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
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.
Judy Hennessey / PrecisionBI
-
- Posts: 7341
- Joined: Tue Mar 20, 2018 5:34 am
Re: Workdays Calculation - omit Saturday, Sunday
Hello,
Thank you for the information.
Thank you for the information.