Mike,
Thanks for the reply.
There were a couple dealing with skipping weekends and holidays, but they started with a begin and end date and excluded days between.
I've tried converting the begin date to float to use in calculations, but found that it is not accurate enough.
set @BegDate = '01/15/2003 11:00:00'
set @fBegDate = cast(@BegDate as float)
print cast(@fbegdate as datetime)
set @BegDate = '01/15/2003 11:01:00'
set @fBegDate = cast(@BegDate as float)
print cast(@fbegdate as datetime)
I have a routine that adds days to a date, excluding weekends and holidays. I can figure the # of days to add (add 40 hours = 4 - 9 hour business days with 4 hours left). It just gets sticky when I run into the next day. I then have to check for weekend or holidays again.
John
>I'm seem to remember seeing something like this in a pervious issue of SQL Mag.
>
>-Mike
>
>>I need to be able to calculate a deadline that is x hours from an input datetime. The calculation has to count only business hours (i.e. 8:00 AM to 5:00 PM) and exclude weekends and holidays. For example, if I have a 4 hour deadline, beginning at 3:00 PM on Monday, the deadline should be at 10:00 AM Tuesday. Likewise a 4 hour deadline at 3:00 PM Friday would be due at 10:00 AM Monday. I have UDF's that determine if a day is a weekend or holiday.
>>
>>TIA
>>
>>John