Discussion board where members can get started with QlikView.
I have the following date format: YYYYMM. I would like to add a month to this format,
but it doesnt seem to work correctly.
for example, if I have a date 201201, the new value must be 201202.
If I have a date 201212, the new value must be 201301.
Help will be appreciated.
use this expression
and to format is again as YYYYMM, you can use Date() function
=Date(MonthEnd(Date#(YourValue, 'YYYYMM'))+1, 'YYYYMM')
Not getting the required format.
Thanks for providing this information