Exclude weekends from the create date and closed date
Summary
Need to exclude the weekends while calculating he date differenceContent
Hi Team,
I am struggling to calculate the time difference between incident creation and closed dates by excluding the weekends. here are the columns and function which I am using to calculate date difference date_diff(incidents.closed,incidents.created), but this logic is counting the days including the weekends. As per requirement I need to exclude the weekends and calculate actual business dates. Could you please help me here on this issue.
Thanks & Regards,
Ashok Ganesh
Version
18C
Tagged:
0