Suppose if Nov 25,Nov 26 and Nov 27 are holidays (consecutive) has to fetch Nov 28 as next working day while current date is Nov 24th
Suppose if Nov 25 and Nov 27 are holidays (non consecutive) then no need to fetch next working day while current date is Nov 24th.
select HolidayDate,CreatedBy,CreatedDate,Description,WeekDay,IsDeleted,ModifiedBy,ModifiedDate from DDS_HOLIDAY_CONFIGURATION order by 1 desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)