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,

       

      Gerhard