6 Replies Latest reply: Feb 17, 2016 12:24 PM by Mark Graham RSS

    Get last week and next week's date using the available date

    Mark Graham

      Hi all,

       

      Here is the data i have:

       

      For every date, i'm trying to get 2 new date fields:

       

      For all the dates between 2/5/2016 to 2/11/2016....  I want 2/19/2016 as deadline, 1/22/2015 as start date

       

      similarly, 2/12/2016 to 2/18/2016 will have 2/26/2016 is deadline and 2/5/2016 is start date

       

      and

      2/19/2016 to 2/25/2016 will have 3/4/2016 as deadline and 2/12 will be start date.

       

      Can someone pls help.

       

       

       

      Eg: For 2/6/2015, i need 1/29/2015,

      Table1:

      LOAD * Inline

      [

      2/5/2016

      2/6/2016

      2/7/2016

      2/8/2016

      2/9/2016

      2/10/2016

      2/11/2016

      2/12/2016

      2/13/2016

      2/14/2016

      2/15/2016

      2/16/2016

      2/17/2016

      2/18/2016

      2/19/2016

      2/20/2016

      2/21/2016

      2/22/2016

      2/23/2016

      ]

      ;