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!