Re: How to calculate time difference excluding weekends (saturday and sunday)
From: deepakp <deepak10000_at_hotmail.com>
Date: Thu, 1 May 2008 13:26:32 -0700 (PDT)
Message-ID: <16b00883-c21d-4558-9d16-73730a3182dc@s50g2000hsb.googlegroups.com>
Date: Thu, 1 May 2008 13:26:32 -0700 (PDT)
Message-ID: <16b00883-c21d-4558-9d16-73730a3182dc@s50g2000hsb.googlegroups.com>
On Apr 30, 2:21 pm, Ken Denny <k..._at_kendenny.com> wrote:
<snip>
> Assuming that date2 is the later date and that neither date falls on a
> Saturday or Sunday, this should do it:
>
> date2 - date1 - 2*(trunc(next_day(date2-1,'FRI')) -
> trunc(next_day(date1-1,'FRI')))/7
</snip>
Ken,
Thank you so much..this works perfectly.
Deepak Received on Thu May 01 2008 - 15:26:32 CDT