I have a datatable build from a .csv file containing dates in a column (header:Date); format “18-05-2024”. I want to filter these dates greater then today Using a ‘for each - if’ statement Cdate(CurrentRow(“Date”).ToString)>Today works just fine but is very much not efficiënt I want to use a filte…

@Luke69 Welcome to the community You can use linq expression liek this in assign Dt = dt.AsEnumerable.Where(function(x) Cdate(x("Date").ToString)>Today).CopyToDatatable Now your table will have only the filtered rows Cheers

Filter datatable from csv on date >= Today

Help Activities

Anil_G (Anil Gorthi) January 26, 2024, 10:37am 6

@Luke69

Glad it helped.Happy Automation

Please close if resolved

Cheers

Topic		Replies	Views
Filter dates greater than today's in excel StudioX studiox , question	10	86	July 21, 2024
How to filter dates later than today in the datatable? StudioX studiox , question	3	58	July 17, 2024
Filter Datatable by current date Studio excel	8	3348	March 4, 2021
How to filter date in excel Studio	1	656	March 2, 2021
How to Filter Excel Data by Today's Date Help excel , activities	13	7735	March 22, 2019

Filter datatable from csv on date >= Today

Related topics