topic Re: Issue with addmonths in QlikView

Issue with addmonths

Mon, 01 Dec 2014 09:41:11 GMT

Hello all,

I have a slight problem with addmonths function.

set errormode = 0;

Let vActualYearAndMonth = date(Today(), 'DD-MM-YYYY');

for i = 0 to 5

let test = addmonths ($(vActualYearAndMonth),-$(i));

NEXT i

As today is 01-12-2014, it should return:

01-12-2014

01-11-2014

01-10-2014

01-9-2014

01-8-2014

but it returns

05-12-99

05-11-99

05-10-99

05-9-99

05-8-99

Do you have an idea why is this happening?

Re: Issue with addmonths

morganaaron — Mon, 01 Dec 2014 09:57:01 GMT

Hi Nemanja,

I think your addmonths statement is calculating the value of vActualYearAndMonth rather than taking it as a date - wrapping it in the DSE will cause it to return it's numerical value of -2025.

Try removing the $( ) from the variable name and see if that works.

Thanks.

Re: Issue with addmonths

anbu1984 — Mon, 01 Dec 2014 10:02:19 GMT

set errormode = 0;

Let vActualYearAndMonth = Today();

for i = 0 to 5

let test = Date(addmonths ('$(vActualYearAndMonth)',-$(i)), 'DD-MM-YYYY');