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.
Buisness Day Calculation
Moderator: Lisa Ennis
-
- Posts: 7
- Joined: Fri Jan 06, 2017 9:50 am
- Contact:
Re: Buisness Day Calculation
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.
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.
Brandon Ritchie
Reports Technical Team Lead
SoftPro
Reports Technical Team Lead
SoftPro
-
- Posts: 23
- Joined: Mon Jan 31, 2022 2:26 pm
Re: Buisness Day Calculation
Thank you, I will take a look.