How to convert month value in format "MM" to "MMMM"

Learning & Development Programs Automation Starter
1

I’m getting value from excel as input which is format “MM/dd/yyyy”
I need to convert split date value to get month value and convert the value format from “MM” to “MMMM”
Example- 10/03/2022
10 to October

2

Hi @priyanka_raja

You can try DataTime.ParseExact function

DateTime.ParseExact(strDate, “MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM”)

strDate = 10/03/2022
Output = October

3

HI @priyanka_raja

Welcome to Uipath community

How about this expression

DateTime.ParseExact(YourString.ToString,"MM/dd/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM")

Regards
Gokul

Regards
Gokul

4

Alternative method @priyanka_raja

CDate("10/03/2022").ToString("MMMM")

image

Regards
Gokul

5

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