Convert Integer 1-12 to Month 01,02

Good Day Community,

I have an action with the following format Start -> If Statement (Count > 12) -> Count + 1 -> Conversion by "CurrentMonth" + FormatDateTime(IntegerttoText(Count)), "MM")

The objective was to have the following value while incrementing, CurrentMonth01, CurrentMonth 02, ... CurrentMonth11, CurrentMonth12.


However the problem is only CurrentMonth01 always appear as the equivalent value even if the Count increments. I honestly am looking for other approach any help would be appreciated.

Thank You!3



Hi Penny! 

If I understand your problem and Count is the initial month "(Count > 12) " is always false.

Regards

Graça

Solution

FormatText(Count,2,2,True,"0") 

Solution

Hi Penny,


1. FormatDateTime need a DateTime input parameter.

2. Where are you putting these values? In a list? Are you using ListAppend to do this?


Edit: 

Bruno's solution is what you want


Regards

I take it you're incrementing count outside that IF

SyntaxEditor Code Snippet

FormatText(IntegerToText(Month),2,2,True,"0")


Regards,

Nuno Verdasca

Regards,

Nuno Verdasca

My guess you have something like this?



Good Day Community 


I would like to give thanks to all your answers. The FormatText happened to answer my problem. Thank you all for your time to even give screenshots of all I need. 


Regards,
Penny