Hi Friends, I need to filter a datatable dt, which is having 50 plus columns and there is one column which is document date. I have two variable in which I have “From Date” and “To date”, means I have to get only data from datatable, which fall under the range of from date and to date variable. I a…

Hi @adishjain Please give the following query a try: filteredDt = (From row In dt.AsEnumerable() Let documentDate = DateTime.ParseExact(row.Field(Of String)("Document Date"), "dd-MM-yyyy", CultureInfo.InvariantCulture) Where documentDate >= fromDate AndAlso documentDate…

Hey @adishjain Filter Data Table activity is working fine for me. You will have to use Filter Data Table activity 2 times. first activity configuration: [image] second activity configuration: [image] Reference file: Test.xaml (10.3 KB)

You only need 1 filter activity. Click on the [ + ] icon to right to add another filter value. However this filter will only work if the target column has a DateTime format. So if it doesn’t work, check the input (or use the dt.select option to convert while filtering)

Your columns must be datetime, not string.

my date is coming in datetime datatype variable

You said it’s a datatable. What’s the datatype of the column in the datatable? If you’re using Read Range or one of the Excel activities to read into the datatable then it’s probably a string column.

yes Postwick, it is comming in string in datatable, and I have two variable of datetime datatype using which I need to filter the datatable

That’s the problem. The columns in the datatable need to be datetime. Use Add Data Column to add two datetime columns. For Each Row in Datatable with Assigns to convert the string dates into actual datetime values (DateTime.Parse or DateTime.ParseExact) into the datetime columns. Then use the ne…

can you please explain with screenshot?

Filter datatable on date range

Help Studio

Shiva_Nikhil (Shiva Nikhil) May 31, 2023, 2:51pm 4

you can try this once it will helps you
dt.AsEnumerable.where(function(a) CDate(a(“ColumnName”).ToString)>=CDate(“01-03-2023”) andalso CDate(a(“ColumnName”).tostring)<=CDate(“05-03-2023”)).CopyToDataTable

thanks and regards

Topic		Replies	Views
Filter DataTable by dates provided by user Help datatable	22	5835	October 14, 2019
How to filter date column in excel datatable using filter datatable activity Help	17	7844	January 4, 2019
Filter datatable column between a date range Studio datatable , studio , question , activities-panel , datetime , datatable-filter	5	335	May 27, 2024
Filter Datatable using range date x to y Help datatable , excel , activities , question	14	7345	November 22, 2019
How to filter date time on data table Learning Hub datatable	4	911	July 10, 2020

Filter datatable on date range

Related topics