General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Came up with a solution. It's in Downloads.
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only