4 Replies Latest reply on Apr 27, 2017 10:43 AM by Shantanu Mendhekar

    Filter on Difference between Dates

    Shantanu Mendhekar

      Hello all,


      I am trying to filter the difference between dates that are in a sequence.


      From the screenshot above, the 'Test - Details' sheet has the the date difference between dates in a sequence. For example, for the first SO, the details are between 'Series Sequence #' 1 and 2, 2 and 3, 3 and 4. I am now trying to filter these differences using a slider filter. Also, I want to select a particular date in the 'From Filter', let's say 'SO Line Create Date', and then the difference should be with the next date in the sequence.


      I have used the 'Quick Table Calculations' to find the difference between sequential dates as you can see. But, I am stuck on how to make it work as a Calculated Field.


      Any help will be appreciated.