In reply to: rohans
Hi Daniel,
I live in Poland and I think for many countries lists of bank holidays is the same, no matter which part of the country you live in. So, to be precise, my proposal could be just an option just like using days off data source on vacation schedule is optional - when this option is turned on then marking of holidays is totally turned off (even for weekends) which makes sense only for companies where each employee has individual work plan.
Hi,
In fact, after marking a non-working day for a given calendar year, the Calendars database table is updated immediately. This immediately affects your vacation schedule.
SELECT TOP (1000) [CAL_ID]
,[CAL_TSInsert]
,[CAL_TSUpdate]
,[CAL_RowVersion]
,[CAL_IsDeleted]
,[CAL_WorkingDate]
,[CAL_IsWorkingDay]
,[CAL_CreatedBy]
,[CAL_UpdatedBy]
FROM [BPS_Content].[dbo].[Calendars]
Best regards,
Darek