2 Replies Latest reply: May 20, 2013 9:51 AM by iain.garey RSS

    Separating a range of dates into different sections

      Hi All

       

      I have a range of "Next Chase Dates" (NCD), some of these will be in the past, i.e. missed, some will be within the 7 days, some 8 - 14 days and some greater than 14 days.

       

      How do I put the below into the script and give each section a name:-

       

       

       

      If the NCD is less than today then call it “Expired”

       

       

      If the NCD is today or within the next 7 days then call it “0 – 7 Days”

       

       

      If the NCD  is between 8 days and 14 days greater than today then call it “8 – 14 Days”

       

       

      If the NCD is greater than 14 days from today then call it “14 Days plus”

       

       

      If there is no NCD then call it “blank”

       

      thanks in advance

       

      Iain