Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
What would the sql statement be to add 3 business days to the Sales Order Delivery Date?
There is probably a shorter version but I got this to work.
CASE
WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=1 then DATEADD(day,3,SO_SalesOrderHeader…