Getting upcoming holidays from a schedule

[TothTamas]

Hello all!

I have a schedule called Holidays in cmn_schedule which has my set up Holidays cmn_schedule_span.
They are a mix of non repeating and repeating holidays, some starting from 2020.

I'm making a script that should check this schedule and decide if today is a holiday based on the schedule or not.

Is there an easy way to check for this, or is there a field i haven't found yet that contains the actual upcoming holiday date?
So far I was using the start date time sorted, and filtered compared to todays date, but this is not working with repeated holidays as their start date time is in 2020.

[Dr Atul G- LNG]

Hi @TothTamas 

Why not use the child's schedule and fix the holiday,.

[TothTamas]

Sadly no.
In short I have a script that should activate or deactivate functions based on if today is a holiday or not.
I would need a field that contains the true start and end dates of holidays as the startdatetime can have dates from years ago.
I could not find any that could give me this, or anything that would calculate an upcoming holiday based on the repeating holidays.

 

[Dr Atul G- LNG]

Sorry mate , cant help much on this.