6 Replies Latest reply: Feb 9, 2017 3:41 AM by Jonathan Dienst RSS

    I need to derive end date from rowno( 2) -1 of start date. Need help in Scripting.

    Raghav B

      Below is my data.

       

      Date1
      12/26/2008
      12/26/2009
      12/26/2010
      12/26/2011
      12/25/2012
      12/25/2013
      12/25/2014
      12/25/2015
      12/24/2016
      12/24/2017

      Output should be like .

       

      Date1Enddate
      12/26/200812/25/2009
      12/26/200912/25/2010
      12/26/201012/25/2011
      12/26/201112/24/2012
      12/25/201212/24/2013
      12/25/201312/24/2014
      12/25/201412/24/2015
      12/25/201512/23/2016
      12/24/201612/23/2017
      12/24/2017Today()

      Plz help.