Skip to Content
Jul 26, 2018 at 07:40 PM

SAP HANA Exclude weekends while calculating diff between two dates.

1139 Views Last edit Jul 26, 2018 at 07:46 PM 2 rev

Hi All,

I have requirement to find out the Number of hour between two dates, but we have to exclude the weekends (Saturday & Sunday).

Example : DATE1 is 19-July and DATE2 is July-26 - Actual diff is - 168 Hours.

Required Output is (168 - 48 Hours (Saturday & Sunday) - 120 Hours.

This I want to achieve using Graphical or Script Cal view, please help me to solve the issue.