for example aug-08, june-06

[image] Gokul001: How about this expression? DateTime.ParseExact("june",{"MMMM","MMM"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.No Hey @ASWATHY_K Try with this it will work for both case aug and june Regards Gokul

Hi @ASWATHY_K Try with this expression DateTime.ParseExact("aug","MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MM") Regards Gokul

HI @ASWATHY_K How about this expression? DateTime.ParseExact("june",{"MMMM","MMM"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM") [image] Regards Gokul

Hello @ASWATHY_K Refer to this thread [image] How to convert Month(Text) into number? Help Hello, I am getting the name of the month in text :i.e. August or March and I would need to convert it to number i.e: 08 or 03. How could I do it? Thank you

Thkz @Gokul001 but this showing a error. [Screenshot (75)]

@ASWATHY_K Try this Month(DateValue("1 "+Month_Name+" 2022")).ToString [image]

Great @ASWATHY_K Kindly close this topic by mark as solved. Regards Gokul

How to convert a month name to its corresponding month number?Any one help pls?

Help Studio

Gokul_Jayakumar (Gokul Jai) December 19, 2022, 6:09am 4

Hello @ASWATHY_K
Refer to this thread

Topic		Replies	Views
How to convert Month(Text) into number? Help	5	12450	September 15, 2019
How to convert name month in number? Learning Hub	17	4809	July 6, 2020
Convert month name to number from extract Studio studio , question , variables_management	6	3015	March 25, 2022
Convert Month Help	2	753	August 18, 2020
Converting month to corresponding number Help	3	3168	September 10, 2019

How to convert a month name to its corresponding month number?Any one help pls?

Related topics