Date plus one month

[gerhardl]

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

[fosuzuki · Accepted solution]

Try this:

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

[gerhardl]

Perfect, thanks