1 2 Previous Next 19 Replies Latest reply on Aug 25, 2016 9:05 AM by ayescas

    overlap times highlight conditional formatting

    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

        1 2 Previous Next