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

    date changes between 2 columns

    David Gabra



      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