2 Replies Latest reply on Oct 23, 2018 6:40 AM by Steve Martin

    Lookup value based on date

    Kayla Wah

      Hello,

       

      I need help coming up with calculated field to help pick up the right value based on a user selected date, from a table.

       

      Example of the lookup table:-

       

      Approval Start DateApproval End DateNameAmount
      1 Jan 201831 Mar 2018ABC500
      1 Apr 201830 Sep 2018ABC250
      1 Jan 201831 Dec 2018DEF1000
      1 Mar 201831 May 2018XYZ150
      1 Jun 201830 Sep 2018XYZ300

       

      So for a given selected date by the user, example 2 Jun 2018, I need the relevant amounts to be picked up by this calculated field. My result should return something like the below if I were to put it in a list:-

       

      ABC -  250

      DEF - 1000

      XYZ - 300

       

      The date selection is a parameter - we can call it [Date Selected]