Checking for Overlap of Dates

UnionSystems

Hi,

I have a "Parent" object that has "Child" objects each with attributes DateStart and DateEnd (both of type Date). The Child object's dates must not overlap. I'm trying to create a rule to confirm this.

Below does not work for me 🙁

if EXISTS Child WHERE (Child IN Child.ob_Parent.om_Child AND Child.ID <> ThisChild.ID AND ((Child.DateStart >= ThisChild.DateStart AND Child.DateStart <= ThisChild.DateEnd) OR (Child.DateEnd >= ThisChild.DateStart AND Child.DateEnd <= ThisChild.DateEnd)) ) Then
REPORT ERROR 'Overlapping dates'

customaware

Here is an extract from the Zero to hero Workshop which deals with overlapping dates.

Not your exact example but might help. Hope it does.

Extract Zero To Hero Beginners Workshop.zip

64.03kB