Filter all days to a specific date

[ppr (Peter Preuss)]

give a try at

Assign Activity
endDate | DataType: DateTime = #09/30/2024#

Assign Activity
dtFiltered =

(From d in YourDataTableVar.AsEnumerable
Let dp = DateTime.ParseExact(d("yourColName").toString.Trim, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture).Date
Where dp >= Now.Date AndAlso dp <= endDate.Date
Select r =d).CopyToDataTable

Handling empty Results:
[FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

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