Hello, I have some problem filtering datatable using filter sequence. so i have datatable from excel, i have to filter it by range date from ‘01/08/2019’ to ‘20/11/2019’. Column Filtered : [image] is filter datatable sequence solve all my problem? or other sequence/code? Thankyou

Filter data table activity will work. Please use between in the filter condition. DateCol date1 BETWEEN date2 Regards, Karthik Byggari

Hi @aliaga , I’ll suggest you to use following code in Assign (After Read range) Dt1 = Dt1.Select("Letter Date >= #08/01/2019# AND Letter Date <= #11/20/2019#").CopyToDataTable here, Dt1 is output variable of read range activity.

[image] samir: Select(“Letter Date >= #08/01/2019# AND Letter Date <= #11/20/2019#”).CopyToDataTable Hello @KarthikByggari , [image] i already use this but it will return 0 rows of datatable. my variable : [image]

Hello @samir , i got this error : [image]

Hey @aliaga , Use this (I’d missed &’ ') dt.Select("[Letter Date] >= '#08/01/2019#' AND [Letter Date] <= '#11/20/2019#'").CopyToDataTable This is working on my side. check it and let me know. :slight_smile:

It won’t work here, because your start and end dates are strings here. Change start and end dates to DateTime variables and try again the filter data table activity. And also try the expression given by @samir In the expression, if column name has spaces we need to enclose column names in square …

Hello @samir , i’ve try use your sequence and it will return this error : [image]

@aliaga , Check the dates in assign filter, Example. if the filter dates range is 1st Jan to 10th Jan and there’s no date falling in the specified range. 1st Feb 23rd Feb 30th March then it is obvious that, you’ll get this type of error, showing Contains no DataRows. So kindly check dates in fi…

Dear @samir , for Static Date what format/variable type i have to input to change #08/01/2019# ? thankyou

Filter Datatable using range date x to y

Help

samir (Samir Mohite) November 22, 2019, 5:34am 8

@aliaga
Use code in my previous post and If you need i’m attaching sample workflow for your reference.

Example.zip (21.0 KB)

Topic		Replies	Views
Filter datatable on date range Studio studio , question , activities_panel	15	1464	June 1, 2023
How to filter date column in excel datatable using filter datatable activity Help	17	7802	January 4, 2019
Filter DataTable by dates provided by user Help datatable	22	5760	October 14, 2019
How to filter date time on data table Learning Hub datatable	4	886	July 10, 2020
Filter dates that occur after one date. Filter Table Activity Help datatable , excel , activities , question	3	1709	October 6, 2021

Filter Datatable using range date x to y

Related topics