I have a create_date column which is in date format. I need to calculate the SLA timings based on create_date column.
I must exclude saturday and sunday and consider business hours like 8 am to 6 pm.
I dont have time dimension and dont have rpd access to . I should do it report only.
Try below formula for finding SLA period. Also you can use dayofweek function if you need.
CASE WHEN (Hour(create_date )+cast(MINUTE(create_date ) as double)/60 BETWEEN 8 AND 18) AND DAYNAME(create_date ) IN ('Fri', 'Mon', 'Thu', 'Tue', 'Wed') then 'SLA Window' else 'Non SLA Window' END