>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
You may want to consider public holidays in this scenario. This involves keeping the holidays in a table and checking the date to see if it is a holiday in your loop.
Cheers,
Jamie