2 Replies Latest reply: Mar 17, 2016 8:51 AM by Gysbert Wassenaar RSS

    Calculate To Date

      Hi,

       

      I Have a Table contains 2 columns,
      I want to add to this table 'To Date' column contains next  row 'From Date' minus a day.

       

      Can someone have an efficient way to do that?

       

      Many thanks

      Jacob

       

      Original Table  

      ProductFrom Date
      A01/01/2013
      A23/04/2014
      A08/07/2014
      B13/01/2016
      B09/02/2016
      B01/03/2016

       

      Output Table:

         

      ProductDateTo Date
      A01/01/201322/04/2014
      A23/04/201407/07/2014
      A08/07/201417/03/2016 (Today Date)
      B13/01/201608/02/2016
      B09/02/201629/03/2016
      B01/03/201617/03/2016 (Today Date)