This content has been marked as final. Show 2 replies
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,