Store month as 0month

[#1]

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]

hi Marc,

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

[florentina_doga]

try this

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

[Anonymous]

may be this?

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

[Chanty4u]

if you have fixed value then try below

[jjbom1990]

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

[sunny_talwar]

Try this:

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

[Anil_Babu_Samineni]

Sometimes, the problem with Date Field,

Perhaps this

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