Ok quick sum of what I have. My BAQ is used to give a demand amount via part & due date. I have the table PartDtl with criteria of
{ DueDate <= Current date +1 Day(s)
}
So it gives a daily demand of what we need, which is equal to all past due demands plus today and one day out. Works fine, until we test it on a friday when one day out is actually 3 days out since the next work day for demand is Monday not the +1 day that would be saturday. An easy fix with an if else statement, but not avaible in the BAQ or in portal where there is being used.
Any ideas how I can track this in the BAQ to change to +3 days if it is the 6th day of the week?
{ DueDate <= Current date +1 Day(s)
}
So it gives a daily demand of what we need, which is equal to all past due demands plus today and one day out. Works fine, until we test it on a friday when one day out is actually 3 days out since the next work day for demand is Monday not the +1 day that would be saturday. An easy fix with an if else statement, but not avaible in the BAQ or in portal where there is being used.
Any ideas how I can track this in the BAQ to change to +3 days if it is the 6th day of the week?