Ship_date = date() - 4
Order_Date = date() - 6
lnWeeks = INT((Ship_date - Order_Date) / 7)
lcThisWeekDay = Order_Date + lnWeeks*7
lcFullWeekDays = lnWeeks*5
IF WEEK(Ship_date,1,2) > WEEK(lcThisWeekDay,1,2)
WAIT WINDOW lcFullWeekDays + (Ship_date - lcThisWeekDay - 2)
ELSE
WAIT WINDOW (Ship_date - lcThisWeekDay - IIF(TRANSFORM(DOW(Ship_date,2)) $ [67],DOW(Ship_date,2)-5, 0)) + lcFullWeekDays
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
