How to Convert DateTime format from "/" to "-"

Help Studio
, ,
1

Hi ,
I am getting date explicitly like (String) startDateStr= 14-03-2020 12:28:14 IST, now iam removing IST from that and storing it in cleanedStartDateStr(String)
now I want to convert that string format to DateTime format, for that I have done like below

image
image772×391 14.9 KB

but after converting to DateTime format I am getting result as 03/14/2020 12:28:14
but i need in a format of 14-03-2020 12:28:14 in DateTime type.
how can i fix this issue ? please help

2

do this @rajesh.m
startDate.toString("dd-MM-yyyy HH:mm:ss)

3

@rajesh.m

cleanedStartDateStr = DateTime.ParseExact(startDateStr.Replace(" IST", ""), "dd-MM-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy HH:mm:ss")

Import System.Globalization

4

Hi @rajesh.m

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

image
image966×380 14.1 KB

Regards,

5

Hi @rajesh.m

Try below expression

cleanedStartDateStr = DateTime.ParserExact(cleanedStartDateStr.Replace(“IST”,“”).Trim,“dd-MM-yyyy HH:mm:ss”,system.globlization.cultureinfo.InvariantCulture).tostring(“dd-MM-yyyy HH:mm:ss”)

Happy Automation :slight_smile:

6

@rajesh.m

How about the following?

image
image599×662 19.6 KB

image
image993×714 25.6 KB

Regards,

7

Hi @rajesh.m

You can’t get the output in DateTime variable because your preferred output is of the format dd-MM-yyyy HH:mm:ss so you will get the output dataType as System.String. If you want the output in System.DateTime DataType format variable your output will be of format MM/dd/yyyy HH:mm:ss.

startDateStr= "14-03-2020 12:28:14 IST"

Output= DateTime.ParseExact(startDateStr.ToString.Replace("IST",""),"dd-MM-yyyy HH:mm:ss ",System.Globalization.CultureInfo.InvariantCulture)

In the above case, Output will be of DataType System.DateTime

image
image1009×683 21.4 KB

DataType:
image
image937×643 20.7 KB

startDateStr= "14-03-2020 12:28:14 IST"

Output= DateTime.ParseExact(startDateStr.ToString.Replace("IST",""),"dd-MM-yyyy HH:mm:ss ",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy HH:mm:ss")

In the above case Output will be DataType System.String

image
image960×656 20.1 KB

DataType:
image
image948×631 21.5 KB

Hope it helps!!

8

@rajesh.m

If you just use .ToString or print a datetime variable then it uses the default system format

If you need any specific format you need to specify that in the .ToString("dd-MM-yyyy HH:mm:ss") as you need

Cheers