Date conversion issue using uipath

[ppr (Peter Preuss)]

have an example on a cascade to handle different scenarios

Linq query in excel date

@purnima_mandan when working with dates and Excel we check the datatable contents and will not rely at the visual presented format from excel Your Excel- read range with EAS: [grafik] Your excel - read range with Workbook [grafik] To find the latest date within a defensive approach we can do the following and run it against a prepared test set: [grafik] Checking totally invalid dates [grafik] Assign Activity: MaxDate | DateTime = (From d In dtData.AsEnumerable Where Not (isNothing(d(…

and feel free to adapt it to your scenario also by decomposing the LINQ to essential activities