Before Every new year,there is a need to create a new birthday email template for the new year in html format.
My robot is checking last run date as an input dialog to differiate between sending out belated birthday email for dob > last run date and send out birthday email for today date. I unable to run the bot on weekend and public holiday.
First scenario: What if a certain year where 31 dec of the year falls on the saturday. And i only able to run the robot on the next working day of the new year?
Second scenario: what if 31 dec falls on Sunday ,then i only able to run the robot on the 3rd of jan (tuesday) as 1st jan is a new year and 2nd jan is a entitlement public holiday.
How do i develop the bot to know that the bot have to use the last year birthday template by selecting file of the last year birthday email template for the belated birthday when i run the bot on any of the first few days of the new year?