Convert datetime

[ppr (Peter Preuss)]

@alan_prakash

Actually i need to compare this date with one of the excel coloumn

we would do it at DateTime base
Parsing Option was given to you e.g. here:

@ppr

DateTime.ParseExact(YourStringVar, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)

Ensure the correct doublequotes of " and not the inverted ones e.g. by a copy& paste

When also Parsing the other Column Value you can use both within the Condition

Also have a look here as Excel visual presented values are not mandatory the value within a datatable:

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum