Hi
i have a database the has jobs that have a start_date and an end_date.
These are in the format dd/mm/yyyy hh:mm and could cover any period.
The business has time periods where these jobs are allowed to run outside of key business hours
For example between 18:00 to 08:00
I need to identify jobs that are within this period or are outside of this period.
i understand that I will have to identify anything the runs over the total allowed time to capture those that run over multiple days etc.
What I can’t achieve is the time testing elements as some run over midnight etc and I can’t produce a method that is 100%
correct.
Can anyone suggest a method?
Many thanks Phil