21 Replies Latest reply: Jul 25, 2016 2:58 PM by Ling Zhang RSS

    Timestamp field between two other fields

    Nick Listerman

      See attached.  I'm thinking this is a formatting issue but I've lost enough time to figuring it out myself.

       

      I'm trying to write the set analysis for Task_Opened_At is between Visit_FirstViewByDay and Visit_IncidentWindowEnd but nothing has worked for me.  The results should be zero so I'm testing with Task_Opened_At <= Visit_FirstViewByDay and >= Visit_IncidentWindowEnd.  This should count all the records but I'm getting no results.