3 Replies Latest reply on Oct 20, 2017 3:58 AM by David Gabra

    date changes between 2 columns

    David Gabra

      HI

       

      Please can you add a calculated field showing the date difference (in days)  between   [use the string converted to date]

       

      1. a) days difference between The last entry on the 001  to the last entry on the 117
      2. b) This need be fixed per employee – since I want to run on 1000s of employee.

       

      I think it means to take the the date from the 017 column and  then minus it from the date that corresponds to the last entry on the 001 column -

       

      so it would be 31st aug - 31 july in this case


       

       

       

       

       

      Thanks

      David.