>Hi all
>I have a table with two field - order_date and ship_date - I want to know the days from the customer ordered till when we shipped, but I want to ignore from friday an saturday (if we got the order in thursday and we shipped it in sunday it's will be considerd as one day and if we got the order in monday and shipped in wednesday is 2 days).
>Thank's
? Ship_date - Order_Date - IIF(TRANSFORM(DOW(Ship_date,2)) $ [67],DOW(Ship_date,2)-5, 0)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.