My trigger needs to run from monday to friday, from 7am to 7pm, excluding on bank holidays.
How to implement these bank holidays ?
A "bad" solution comes into my mind :
- store into a table the bank holidays of the year
- create 1 "regular" trigger for all the months without bank holiday
- create 1 "specific" trigger for each month with a bank holiday, excluding the day(s) concerned
But, I can't find a character meaning "excluding"? (everything without)
Thank you for your help
|