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

Gokul_Jayakumar (Gokul Jai) November 10, 2022, 6:37am 4

Hello @tharani.natarajan
By using a filter data table you can filter the data
Kindly find the xaml file, you may get some idea.
Forum_DateFilter.zip (10.2 KB)

Input

Output

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