Compare dates from a Data Table

Help Studio
, ,
4

we assume that the date are within a default format, otherwise analyze it as described below:
:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Variable: filterDate | DataType: DateTime =

DateTimeParseExact("20240101","yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).Date

(From d In dtData.AsEnumerable()
Let dp = CDate(d("YourDateColumn").ToString().Trim).Date
Where  dp > filterDate
Select r = d).CopyToDataTable()

Empty Result Handling:
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum