Page 1 of 1
Buisness Day Calculation
Posted: Tue Feb 27, 2024 8:03 pm
by elimalone19
Hello,
Is there a function I could leverage in a custom stored procedure to calculate a due date? I need to add x number of business days to a date I'm querying.
Re: Buisness Day Calculation
Posted: Wed Feb 28, 2024 7:47 am
by brandon.ritchie
There are 3 business days functions with the default bundle that might help get what you need.
rptdoc.BusinessDaysInDateRange
rptdoc.BusinessDaysInDateRangeByDateManagerID
rptdoc.BusinessDaysInDateRangeNoTimeDateManagerID
Some of these were added recently so if they are unavailable in the SelectDb you would need to ensure you have the latest default main bundle install. This available for download on the documents portal.
https://blog.softprocorp.com/the-softpr ... nts-portal look for "Default Documents and Reports" under national packages.
Re: Buisness Day Calculation
Posted: Wed Feb 28, 2024 11:23 am
by elimalone19
Thank you, I will take a look.