Hi All , I have column in datatable where data is 08/11/2022 12:30:00 How to filter using date and take row where date is equal or greater than current date.

HI @tharani.natarajan Checkout this expression DtTest.AsEnumerable().Where(Function(d) DateTime.ParseExact(d("Column1").ToString,{"dd/MM/yyyy hh:mm:ss","MM/dd/yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None)>=DateTime.Now).CopyToDataTable …

Split date time from excel

Help Studio

system (system) Closed November 13, 2022, 6:38am 5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Filter DataTable for Future Dates Studio studio , question	11	1537	June 26, 2023
Filter DataTable(from Excel) on column containing Date Studio studio , question , activities_panel	8	953	November 4, 2022
Linq to filter "Date" column in datatable Studio studio , question , activities_panel	8	3460	October 28, 2022
Filter datatable that has an excel date Studio studio , question , outline_panel	2	695	June 19, 2022
Filter today date StudioX excel	7	1004	February 13, 2023

Split date time from excel

Related topics