2 Replies Latest reply on Oct 15, 2018 10:31 AM by Don Wise

    Possible to split some data with a calculated field?

    Justin Pulley

      The attached file has the data; it has a column for start, end and the day that start and end was created.
      what I am trying to see if I can make happen is the following:

       

      a column with the max create date, a column with the start date associated with that latest create date, but then I need a column that has the Previous date to the MAX create date in that column with the associated start date.  Can anyone think of what the calculations are that will need to be done to do that?