Hello, I have a questions and it is…
I have created_date
and resolved_date
as columns in tickets
table. In other table I have sat_calendar with all days since 2020-06-01 and I identified Sunday, Saturdays and Holidays in description
column.
But now I need to calculate difference between created_date
and resolve_date
in working_days.
I did new table with row_number to working_day but I couldn’t do put ‘the previuos’ number if the created or resolved date is some holiday.
Could someone help me please?