How to Convert 09/26/2022 00:00:00 to 26-SEP-2022

Help Activities
, ,
1

Anyone please do suggest a expression

2

HI @Gopikrishna_S

You can try with this expression

DateTime.ParseExact(StringInput.ToString,"MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy")

Regards
Gokul

3

HI @Gopikrishna_S

Check out the another expression

DateTime.ParseExact(StringInput.ToString,"MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy")

image

4

Hi @Gopikrishna_S

It will get the Month in the Upper case

DateTime.ParseExact("09/26/2022 00:00:00","MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy").ToUpper

image

5

its working. I have another Doubt in 09/26/2022 00:00:00 if i want to remove this 00:00:00 time stamp what expression I need to give

6

Hi @Gopikrishna_S

You can try with Regex Expression

System.Text.RegularExpressions.Regex.Replace(YourString,"\b\d{2}:\d{2}:\d{2}\b","").Tostring

image

Regards
Gokul

7

Thanks Gokul, I have got the Required Output :slightly_smiling_face:

1 Like
8

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