Calendar of days off calculation

0

You can use following scenario:
1) In Designer Studio go to System Settings - Working days calendar and set options ( Non-working days of week and non-working dates) for current year.
2) create rule based on sql query from content db table - Calendars ( column CAL_IsWorkingDay) to check numbers of working days between the dates / check if provided date is working day or no.

Can you write it in more detail? I tried and it doesn't work.
Thank you in advance

I set Number 1 but 2 doesn't work

Here you are.

Work on a single date.
It does not work when there are holidays in the time period.
e.g.: the weekend is free - when selecting from Friday to Monday, the rule does not work.
Please help
Thank you in advance

if exists
( select cal_isworkingday from calendars where CAL_WorkingDate>=START_DATE and
CAL_WorkingDate<=END_DATE and CAL_IsWorkingDay=0)
select 'Time period contain non working days'
else
select 'All days in provided time period are working days'


put values in START_DATE and END_DATE
you can use query to build validation rule.