Date conversion not working

Hi
I am trying to convert date yyyy-MM-dd HH:mm:ss to format MM/dd/yyy using datetime.parseexact(“2021-10-31 01:17:09”,“yyyy-MM-dd HH:mm:ss”, System.Globalization.Cultureinfo.InvariantCulture).Tostring(“MM/dd/yyyy”)
But getting error message string was not recognised as a valid date time.
How can I rectify this error. Please help

@Rilna_Rilna

Welcome to our UiPath community.

Please try below expression.

     CDate("2021-10-31 01:17:09").ToString("MM/dd/yyyy")
1 Like

Hi,

Your expression seems no problem as the following.

Can you try the following sample?

Sequence1.xaml (4.5 KB)

Regards,

1 Like

Hi

Welcome to UiPath forum

You are almost done

If the input variable of string named strinput is of this format

Then use a assign activity like this

stroutput = DateTime.ParseExact(strinput.ToString.SubString(0,10).ToString.Trim, “yyyy-MM-dd”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)

Cheers @Rilna_Rilna

1 Like

It works now. Though not sure what was the mistake I did. Thanks

1 Like

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