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

Help Studio
1

for example aug-08, june-06

2

Hi @ASWATHY_K

Try with this expression

DateTime.ParseExact("aug","MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MM")

Regards
Gokul

3

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

4

Hello @ASWATHY_K
Refer to this thread

5

Thkz @Gokul001
but this showing a error.

Screenshot (75)
Screenshot (75)1366×768 115 KB

6

Hey @ASWATHY_K

Try with this it will work for both case aug and june

Regards
Gokul

7

@ASWATHY_K
Try this

Month(DateValue("1 "+Month_Name+" 2022")).ToString

image

8

Thkz this is working

1 Like
9

Great @ASWATHY_K

Kindly close this topic by mark as solved.

Regards
Gokul

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.