String was not recognized as a valid DateTime error even after using DateTime.ParseExact

[Palaniyappan (Palaniyappan P)]

@Nikhil_kathpalia

yyyy-MM-dd hh:mm:ss

Hi

Welcome to UiPath forum

Try with this expression

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

Output will be of DateTime

If you need in string of specific format

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

I want to suggest you one thing

You are almost right…

The only thing is timestamp

It’s in 24 hours format then hours should be in HH
But you have mention as hh in that DateTime expression

Change it to HH and give a try or
Try with the above suggestion

It should be fine

For more details on DateTime in UiPath

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (https://forum.uipath.com/t/all-about-datatable-uipath/386445) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm…

Cheers @Nikhil_kathpalia