Thanks @Somesoni for above solution.
I am still stuck in a scenario where there are 2 or more consecutive day holiday in holiday.csv.
The above solution work fine for 1 day holiday.
But if below if the condition then it fails again:-
1.On Saturday 4th Feb it should pick earliest time of 6th Feb
2. Take 6th and 7th Feb both as holiday in holiday.csv
3. Above query will check if 6th Feb is a Holiday in holiday.csv and if true it will pick earliest time as
7th Feb even though 7th is also a holiday in Holiday.csv.
... View more