Hello guys,
I desperately need your help with my query which supposed to provide me with an information about hours between 2 dates/time, the only hook is that I would need to somehow get rid of all the weekends between the dates because the idea of this query is to track SLA and weekends can not be calculated within the final number as our regular working days are from mon-fri. So basically I have 2 dates/time stamps one next to other(see attached example) and I have calculated the difference between these two using Datediff function but dont know how to exclude weekends from it. Any idea how this could be possible?
Many thanks.
I desperately need your help with my query which supposed to provide me with an information about hours between 2 dates/time, the only hook is that I would need to somehow get rid of all the weekends between the dates because the idea of this query is to track SLA and weekends can not be calculated within the final number as our regular working days are from mon-fri. So basically I have 2 dates/time stamps one next to other(see attached example) and I have calculated the difference between these two using Datediff function but dont know how to exclude weekends from it. Any idea how this could be possible?
Many thanks.
Attachments
Last edited: