Hi collegues,
I'm trying to figure out if there is a smart way to identify, given a certain day, if is a working day or a public holiday. The result I would like to expect would be something like this table above, in which I have the right assignment for each day on the type column:
| day | month | year | type |
|---|---|---|---|
| 01 | June | 17 | working_day |
| 02 | June | 17 | working_day |
| 03 | June | 17 | working_day |
| 04 | June | 17 | public_holiday |
| 05 | June | 17 | working_day |
| 06 | June | 17 | working_day |
| 07 | June | 17 | working_day |
| 08 | June | 17 | working_day |
| 09 | June | 17 | working_day |
| 10 | June | 17 | working_day |
| 11 | June | 17 | public_holiday |
Any suggestions?
Thanks in advance.
-Giulio