Convert date format to format that will be used for MySQL insertion

[hjie30 (Marcus)]

Hi guys, I am trying to convert this date format dd/mm/yyy to format YYYY-MM-DD. And how do I change to date datatype? Cause I will need this datatype for database insertion.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@hjie30
Try with this
xmalDate=“dd/mm/yyy”

DateTime.ParseExact(xmlDate, "YYYY-MM-DD",
           System.Globalization.CultureInfo.InvariantCulture)

[hjie30 (Marcus)]

May I know why I got this error?

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@hjie30
Remove .tostring in expression and try

[Rahul_Unnikrishnan]

Hello @hjie30

Another approach is by using the modify date activity.

How to Modify Date in UiPath? Modify Date activity explained with demo

Thanks

[hjie30 (Marcus)]

@sangeethaneelavannan1

Remove .tostring in expression and try

.ToString is requried else error will be prompted.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@sangeethaneelavannan1

DateTime.ParseExact(xmlDate, "YYYY-MM-DD",
           System.Globalization.CultureInfo.InvariantCulture)

(DateTime.ParseExact(xmlDate, “YYYY-MM-DD”,
System.Globalization.CultureInfo.InvariantCulture)).ToString(“YYYY-MM-DD”)

[hjie30 (Marcus)]

I think I found where’s the error which that your answer given that you parse the source date string in wrong way, my source date format is dd/MM/yyyy and result is yyyy-MM-dd

So, I will have to use

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

Thank you! that solved my issue