2 Replies Latest reply: Jan 22, 2013 8:04 AM by Gerhard Laubscher RSS

    Date plus one month

    Gerhard Laubscher

      Hi There,


      I load a specific date like this:


      DATE(DATE#( left([Posted Date],11), 'DD-MMM-YY')) as [Posted Date],




      Please help me load an additional field which is a date exactly one month later (same day of the month, but one month later).


      So if [Posted Date] = 2013/01/22 then [Next Month] = 2013/02/22

           if [Posted Date] = 2012/12/05 then [Next Month] = 2013/01/05



      Thanks in advance,