AnsweredAssumed Answered

overlap times highlight conditional formatting

Question asked by ayescas on Aug 23, 2016
Latest reply on Aug 25, 2016 by ayescas

Hello,

 

Need help with the following code, which works when comparing two records, but breaks when 3 or more records are compared.

 

(

PreviewWindow::StartTime  <  AssignedPersonSameDay::StartTime

and

PreviewWindow::StartTime  >  AssignedPersonSameDay::EndTime

)

or

(

PreviewWindow::EndTime  ≥  AssignedPersonSameDay::StartTime

and

PreviewWindow::EndTime  ≤  AssignedPersonSameDay::EndTime

)

or

(

PreviewWindow::StartTime  ≥  AssignedPersonSameDay::StartTime

and

PreviewWindow::StartTime ≤  AssignedPersonSameDay::EndTime

)

 

What is missing to make this work if 3 or more records are compared.  This only works when looking at 2 records.  Many thanks.

 

Alex

Outcomes