topic Re: How to add months to YYYYMM format in QlikView

How to add months to YYYYMM format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

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.

Thanks,

Stefan

Anonymous — Thu, 19 May 2016 12:12:12 GMT

use this expression

addmonths(date#(yourdates,'YYYYMM',1)

sunny_talwar — Thu, 19 May 2016 16:00:27 GMT

and to format is again as YYYYMM, you can use Date() function

Date(AddMonths(Date#(yourdates,'YYYYMM',1), 'YYYYMM')

Thu, 19 May 2016 16:30:36 GMT

=Date(MonthEnd(Date#(YourValue, 'YYYYMM'))+1, 'YYYYMM')

nareshthavidishetty — Tue, 17 Jul 2018 08:53:26 GMT

Not getting the required format.

Thanks..

olivierrobin — Tue, 17 Jul 2018 09:36:01 GMT

maybe that

let m=201212;

let m1=date(AddMonths(date#(m*100+1,'YYYYMMDD'),1),'YYYYMM');

sunny_talwar — Tue, 17 Jul 2018 11:09:02 GMT

Thanks for providing this information