3 Replies Latest reply on May 3, 2018 4:34 AM by Stephen Brown

    Comparing Dates using Lookup

    Stephen Brown

      I need to build a function that compares the dates of visits from patients to an Emergency Department, and list the time in days between the visits. 


      I thought Lookup might work, but I am getting an error that all fields need to be aggregate fields.  Any ideas would be appreciated.  Thanks.


      DATEDIFF('day', [Arrival Date],  LOOKUP([Arrival Date] - 1 )   )