>>? Ship_date - Order_Date - IIF(TRANSFORM(DOW(Ship_date,2)) $ [67],DOW(Ship_date,2)-5, 0) >>>???
Ship_date=date() >Order_Date=date()-30 >?Ship_date - Order_Date - IIF(TRANSFORM(DOW(Ship_date,2)) $ [67],DOW(Ship_date,2)-5, 0)I see what you mean :o)
Ship_date = date() Order_Date = date()-30 ** How many weeks are passed from order date to sheep date lnWeeks = INT((Ship_date - Order_Date) / 7) ** Get the from Ship date week when full week ends lcThisWeekDay = Order_Date + lnWeeks*7 WAIT WINDOW (Ship_date - lcThisWeekDay - IIF(TRANSFORM(DOW(Ship_date,2)) $ [67],DOW(Ship_date,2)-5, 0)) + lnWeeks*5