4 Replies Latest reply on Jun 16, 2016 2:04 PM by d Vermaak

    I need help with a calculated field that compares 2 date values!

    d Vermaak

      Hi everyone!

      I have 2 tables:

      • 1 that displays a list of store and their opening date.
      • 1 that displays a list of injuries, the store the injury occurred at, and the date of the injury.

       

      What I want to do is create a calculated field that determines how many stores were open on the date of injury. Essentially, a sum of all open stores on the date of injury?

      Does this make sense?

      I'm attaching the workbook.

      Any help would be appreciated!