Report Date Diff Excluding Weekends
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
Answers (1)
Please log in to answer
Posted by:
cblake
11 years ago
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
Comments:
-
Thanks, I will try it out. - kaneda0149 11 years ago
