Hi, I’m trying to filter rows from a data table, with date > “2017-30-12” but i don’t got any result. Did anyone know why ? [Screenshot 2020-03-23 at 22.50.36] Tx

[image] Hadrien_Poquet: date > “2017-30-12” @Hadrien_Poquet , Please ensure DataType of your date column is DateTime. Cheers

Hi @Doanh , Do you have the expression that fit in an if activity ? Tx

[image] Doanh: Filter DataTable only works with STRING data type column. This is not remotely true. @Hadrien_Poquet What is the datatype of the Date column?

@DanielMitchell Sorry it’s my mistake. In this case, how can we extract structure data to a datatable variable with datetime type column? @Hadrien_Poquet You can try this Assign dt_WorkItems2 = dt_WorkItems.AsEnumerable().Where(Function(x) CStr(x(“Description”)).Equals(“Verify Account Position”…

Can't filter the date using the data wizard

Learning Hub

Doanh (Do Anh) March 24, 2020, 12:36am 2

@Hadrien_Poquet
Filter DataTable only works with STRING data type column.
For other data type (int, date), you have to use other way as For Each Row or expressions

Topic		Replies	Views
Filter datatable on date range Studio studio , question , activities_panel	15	1473	June 1, 2023
Filter DataTable by dates provided by user Help datatable	22	5769	October 14, 2019
I wanted to filter out a date range(Variable type : String) in DataTable Activities datatable , excel , uiautomation , question	2	677	December 13, 2022
Date Filtering Issue in Filter Data Table Activity Marketplace marketplace , question	16	3786	March 27, 2022
Convert and Filter Data Table Studio datatable , studio , question , activities_panel	9	2680	November 9, 2021

Can't filter the date using the data wizard

Related topics