Buisness Day Calculation

[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.

[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.

[elimalone19]

Thank you, I will take a look.