https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49323#M60 Hello Linda, <DIV></DIV> <DIV>You can use the following expression where your input would be the Month in text and in the output you get the Month Number.<BR /><BR />Also, this will work with the full Month Name (December) and also with a short form like Dec, Jan, Feb, etc., as well.<BR /><span class="lia-inline-image-display-wrapper" image-alt="5783.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/5961i128CB710858F091C/image-size/large?v=v2&amp;px=999" role="button" title="5783.png" alt="5783.png" /></span><BR />Let us know how it goes.</DIV><BR /><BR />------------------------------<BR />If I was of assistance, please vote for it to be the "Best Answer".<BR /><BR />Thanks &amp; Regards,<BR />Tejaskumar Darji<BR />Sr. Consultant-Technical Lead<BR />------------------------------<BR /> Tue, 02 Aug 2022 16:47:00 GMT Tejaskumar_Darji 2022-08-02T16:47:00Z https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49321#M58 -- Tue, 02 Aug 2022 08:36:00 GMT https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49321#M58 Linda1 2022-08-02T08:36:00Z https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49322#M59 Use this " <STRONG>FormatDate(Today(), "MM")</STRONG> "expression in calculation stage&nbsp;<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="5782.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/5965iE7E29F4BE7E86D7D/image-size/large?v=v2&amp;px=999" role="button" title="5782.png" alt="5782.png" /></span><BR /><BR />------------------------------<BR />Ram Prasad Gajula<BR />Software engineer<BR />EY<BR />Bangalore<BR />+919704497828<BR />------------------------------<BR /> Tue, 02 Aug 2022 11:00:00 GMT https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49322#M59 ramprasad.gajula 2022-08-02T11:00:00Z https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49323#M60 Hello Linda, <DIV></DIV> <DIV>You can use the following expression where your input would be the Month in text and in the output you get the Month Number.<BR /><BR />Also, this will work with the full Month Name (December) and also with a short form like Dec, Jan, Feb, etc., as well.<BR /><span class="lia-inline-image-display-wrapper" image-alt="5783.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/5961i128CB710858F091C/image-size/large?v=v2&amp;px=999" role="button" title="5783.png" alt="5783.png" /></span><BR />Let us know how it goes.</DIV><BR /><BR />------------------------------<BR />If I was of assistance, please vote for it to be the "Best Answer".<BR /><BR />Thanks &amp; Regards,<BR />Tejaskumar Darji<BR />Sr. Consultant-Technical Lead<BR />------------------------------<BR /> Tue, 02 Aug 2022 16:47:00 GMT https://community.blueprism.com/t5/Digital-Exchange/How-to-Convert-month-name-to-month-number-eg-December-to-12/m-p/49323#M60 Tejaskumar_Darji 2022-08-02T16:47:00Z