Convert datetime into month year format

[Swara_Soni (Swara)]

How should i convert the shown below date time format to MMMM yyyy format Like (January 2020) format in excel

Please help

[Anthony_Humphries]

If that output is coming from a datetime type variable, you can use MyDate.ToString("MMMM yyyy"), where MyDate contains the datetime you’ve displayed above.

[Manish540 (Manish Shettigar)]

Check this below code, @Swara_Soni
DateTime.ParseExact(“01/03/2019 00:00:00”,“MM/dd/yyyy HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM yyyy”).
Hope this may help you

[Srini84 (Srinivas Kadamati)]

@Swara_Soni

Check as below

Mark as solution if this helps

Thanks

[shetanshudhar]

Hi Swara,
The solution is very simple:-

1. read the date time value to a string variable.
2. convert to LongDateString.
   This 1 line of code could get output like what you want.

assign variablename=datetimestringvariable.ToLongDateString