LINQ Query Troubleshooting

Help Studio
, ,
2

Hi @Mahii

Welcome to uipath community

Try with this expression

DTInput1.AsEnumerable.Where(Function(x) x.Item(If(("Column Name").Contains(""),("Column Name"),If((“Column Name”).Contains("dd.MM.yyyy"),Datetime.ParseExact(("Column Name"),"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).Tostring("MM/dd/yyyy"))))).CopyToDataTable

Regards
Gokul