Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi Marc,
try this varCurrentMonth = num(Month(Today()),'00');
try this
=if(len(num(Month(Today())))=1,'0'&num(Month(Today())),num(Month(Today())))
may be this?
varCurrentMonth = right(num(Month(Today())),1);
if you have fixed value then try below
that would mean that when it is oktober the month would be 010, does not seem to be the requested outcome.
Try this:
varCurrentMonth = Num(Month(Today()), '00');
Sometimes, the problem with Date Field,
Perhaps this
varCurrentMonth = Num(Month(Floor(Today(),'DateFieldFormat'),'MM'))