View Single Post

   
  #5 (permalink)  
Old 05-02-2008, 05:05 AM
deepakp
 
Posts: n/a
Default Re: How to calculate time difference excluding weekends (saturday andsunday)

On Apr 30, 2:21 pm, Ken Denny <k...@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

Reply With Quote