DateTime Format Not Working

[marina.dutta]

Hi All,

I want to convert my Date strStartDate:01/7/2023 into 01/07/2023.

I am using below format however its not working.

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

[Anil_G (Anil Gorthi)]

@marina.dutta

Please try this

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

Cheers

[Parvathy (PS Parvathy)]

Use this syntax:

Hi @marina.dutta

DateTime.ParseExact(strStartDate,“dd/M/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Store it an string variable.

Regards,

[fernando_zuluaga]

Hi @marina.dutta

Try with

DateTime.ParseExact("01/7/2023",{"dd/M/yyyy", "d/M/yyyy"},System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards

[Yoichi]

Hi,

FYI, another approach using regex.

System.Text.RegularExpressions.Regex.Replace(strStartDate,"(?=\b\d\b)","0")

Regards

[marina.dutta]

@Anil_G

my strStartDate is of String type. When I am using

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

It throws me an error.

[Anil_G (Anil Gorthi)]

@marina.dutta

StrStartdate is string …and what is the datatype of the variable in assign on the left side? It should be string too

Cheers

[Parvathy (PS Parvathy)]

Hi @marina.dutta

Use this syntax and store the output in string variable

DateTime.ParseExact(strStartDate.ToString,“dd/M/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards,

[Vikas_M]

Hey @marina.dutta ,
Below is the code
DateTime.ParseExact(strStartDate,"dd/M/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Below is the screenshot of the output

below is the file for your refernce
Testt.zip (10.4 KB)

Hope it helps you