I have a excel with 3 columns-Name, amount and date.I want to filter date column with future date. i want to remove all the rows with future dates. [image]. Is there any way to do this either by using linq query or filter data table i want the output like this below excel [image]

Filter DataTable for Future Dates

kumar.varun2 (Varun Kumar) August 3, 2022, 11:08am 7

The date column must contains all the values in the dd.MM.yyyy format and should not have empty values for the above query to work

If possible please share the sample excel file.

Could you please share the error screenshot also.

Please go through this post also @amruta_George

Topic		Replies	Views
Linq to filter "Date" column in datatable Studio studio , question , activities_panel	8	3023	October 28, 2022
Filter datatable that has an excel date Studio studio , question , outline_panel	2	633	June 19, 2022
Split date time from excel Studio studio , question , activities_panel	4	479	November 10, 2022
Filter data table with dates Activities excel , activities , studio , question	13	793	July 13, 2023
Linq query(2) Help datatable , excel , uiautomation , studio	16	3432	September 23, 2019