>>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)
>
???
try
Ship_date=date()
Order_Date=date()-30
?Ship_date - Order_Date - IIF(TRANSFORM(DOW(Ship_date,2)) $ [67],DOW(Ship_date,2)-5, 0)
Thank you
Chaim