Discussion board where members can get started with QlikView.
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,
Go to Solution.
addmonths(DATE(DATE#( left([Posted Date],11), 'DD-MMM-YY')), 1) as [Posted Date+1],