I am trying to create a custom report to determine the date difference between date/time created to today (i.e. DATEDIFF(NOW()-HD_TICKET.CREATED) but I need it to calculate the difference to exclude weekends.  I don't see a calendar table available within the database.

Is there another way of determining the difference in business day (without any rules to modify to ticket date/time)?

 

Thanks for the help!

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

Here's a few examples that might be useful in determining the SQL for your specific need:

http://www.itninja.com/question/limit-reminder-emails-to-certain-hours

Answered 09/17/2013 by: cblake
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity