2 Replies Latest reply on Aug 9, 2017 2:21 PM by Jill Hesse

    Calculated Date fields with Where clauses

    Jill Hesse

      Hello All

       

      I have the following data set up. I have simplified in hopes to focus on my issue.

       

      Sample Name
      Step Date Completed

      Sample 1

      Receiving Step1 Feb 2016
      Sample 1QC Step1 22 Feb 2016
      Sample 1Prep Step 1 28 May 2016

       

      I want to use a calculated field to calculate datediff between Date Receiving Step Completed and the other dates

      I think I want something like [Date Completed] where [Step] = Receiving Step but I am unsure who to set this up

       

      Anyone have any ideas?

       

      Thanks

       

      Jill