Re: How to calculate time difference excluding weekends (saturday and
by deepakp <deepak10000@[EMAIL PROTECTED]
>
May 1, 2008 at 01:26 PM
On Apr 30, 2:21 pm, Ken Denny <k...@[EMAIL PROTECTED]
> 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
