We created a BAQ to help with scheduling and were wondering if there was a way to take a date field and subtract business days from it?
To clarify, we have a “required by” date and our standard “start by” dates are 3, 6, 9 days before the required date based on the size of the job. Is there any way to add a calculated field in a BAQ to do that for us? We already have a calculated field to figure out the days of production (3,6,9).
@dpassenant If you profile is correct and you are 9 that does not apply to you. In the BAQ code KB below there is a section on getting date differences and that you have to convert them to integers. Below is some example ABL that subtracts the dates and then removes weekends. It does not take out holidays.