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


Please log in to comment

Answer this question or Comment on this question for clarity



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


Answered 09/17/2013 by: cblake
Red Belt

Please log in to comment