Thanks Allen,

yeah I think there won't be any issue to display the message if I find a proper way to get the result from the query.

The biggest issue I see that data are not "consistent" from my point of view. Example in the schedule entry [cmn_schedule_span]:

So I would not only have to check the month and day but also the year and whether it repeats.

Basically I can think about 2 scenarious in my case - fixed dates that repeat every year (single record with repeat yearly) and flexible dates (pretty much only Easter in our country) - and these can be scheduled in advance for several years upfront.

For the repeating records - I cannot read from anywhere that there is public holiday on 2021-01-01 unless I really calculate the future date based on the record values (repeat is enabled AND repeat until >= current date). That is my concern.

If there was a simple table record anywhere saying "next occurence is 2021-01-01" that would make things much easier.