topic Re: Store month as 0month in QlikView

Store month as 0month

Wed, 07 Sep 2016 11:17:19 GMT

Dear all,

I create a month variable like this:

varCurrentMonth = num(Month(Today()));

This works fine. However, the month in my dataset is denoted like this: 09, 08 etc... Any thoughts on how I can transform the 9 into 09.

t_moutault — Wed, 07 Sep 2016 11:19:36 GMT

hi Marc,

try this varCurrentMonth = num(Month(Today()),'00');

florentina_doga — Wed, 07 Sep 2016 11:22:55 GMT

try this

=if(len(num(Month(Today())))=1,'0'&num(Month(Today())),num(Month(Today())))

Anonymous — Wed, 07 Sep 2016 11:23:18 GMT

may be this?

varCurrentMonth = right(num(Month(Today())),1);

Chanty4u — Wed, 07 Sep 2016 12:15:05 GMT

if you have fixed value then try below

jjbom1990 — Wed, 07 Sep 2016 12:39:51 GMT

that would mean that when it is oktober the month would be 010, does not seem to be the requested outcome.

sunny_talwar — Wed, 07 Sep 2016 14:30:53 GMT

Try this:

varCurrentMonth = Num(Month(Today()), '00');

Anil_Babu_Samineni — Wed, 07 Sep 2016 15:09:27 GMT

Sometimes, the problem with Date Field,

Perhaps this

varCurrentMonth = Num(Month(Floor(Today(),'DateFieldFormat'),'MM'))