How to: Convert month name to month number eg: December to 12

[Linda1]

--

[ramprasad.gajula]

Use this " FormatDate(Today(), "MM") "expression in calculation stage 



------------------------------
Ram Prasad Gajula
Software engineer
EY
Bangalore
+919704497828
------------------------------

[Tejaskumar_Darji]

Hello Linda,

You can use the following expression where your input would be the Month in text and in the output you get the Month Number.

Also, this will work with the full Month Name (December) and also with a short form like Dec, Jan, Feb, etc., as well.

Let us know how it goes.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------