/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

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