topic Date plus one month in QlikView

Date plus one month

gerhardl — Tue, 22 Jan 2013 12:51:30 GMT

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 — Tue, 22 Jan 2013 13:01:04 GMT

Try this:

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

gerhardl — Tue, 22 Jan 2013 13:04:26 GMT

Perfect, thanks