I’m looking for tips regarding holidays:
The robot need to check emails based on two criterias:
if we are Monday, save mails from monday and saturday
if we are any other week day, check if yesterday was a holiday and if so, save mails from today and yesterday.
For the first one I’m good, but for the holiday I need some help !
The only way I’ve found is to create a list of all of them and check it.
But it’s really not optimal.
Any feedback is welcome,
Thanks in adavance.
@ppr , you always have an interesting approach so I tag you
Holidays are not part of the .Net Api. So we have to take care extra about this.
Implementations using a list are common, when such a part is modelled. It also depends to your more detail requirements e.g. different holidays of substates for a country etc.
looking to the requirement:
we would recommend also to specify the case:
today any weekday except monday, but yestrday was no holiday
You could make a list of holiday dates and put them into an asset, then use that asset in your automation. Most holidays are simple, though - 1/1, 7/4, etc.
The tricky ones are Thanksgiving - you’d have to calculate if it’s the fourth Thursday of the month.
Easter? Basically impossible to calculate unless you’ve also got a Moon phase chart available to read.
As a moveable feast, the date of Easter is determined in each year through a calculation known as computus (Latin for 'computation'). Easter is celebrated on the first Sunday after the Paschal full moon, which is the first full moon on or after 21 March (a fixed approximation of the March equinox). Determining this date in advance requires a correlation between the lunar months and the solar year, while also accounting for the month, date, and weekday of the Julian or Gregorian calendar. It was...
In the end, making a list of holidays for the current year and updating it every year is about the only reliable solution I’ve ever seen. Of course, you could make your asset contain every holiday date for the next 50 years if you wanted, then never have to touch it again.
Thanks for answering Peter, I guess I’ll make a list then
Have a nice day.
Thanks Paul for answering,
All leads lead to this method.
Fortunately I don’t have to worry about Thanksgiving
I’ve found an official website which allow to enter the year you want and you can have all the holiday in a json.
Have a nice day
we would suggest following:
focus on the email list and its creation / retrieval
Have a check on:
a list of holidays of the year
a calculation on dates incorporating the holiday list
could have as a result which can be used for email filter when retrieving the emails e.g. get Mail XX activity (XX-Outlook, Exchange…)
So we have a chance to retrieve only the relevant emails. Maybe this helps.
Indeed it helps, thanks for your time.
I’ve found a holiday list for the next five years so it’s a good start !
Have a nice day
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.