Filter wizard for dates

[Jayasuryan_Chandrasekhar]

How can I filter the data& time column from my excel sheet using the filter wizard? The date value is not recorgnised in the current format due to which there is no output that is coming. Does the date& time format need to be changed? Do we have any packages in UI path for such conversion?

Submit
4/27/2020
4/27/2020
4/27/2020
4/27/2020
4/28/2020
4/28/2020
4/29/2020
4/29/2020

[GBK]

@Jayasuryan_Chandrasekhar - Pls check DataType of your date column is DateTime.

pls refer below link to change the type -

Convert a column of string to datetime

hi guys i’m trying to read an excel file and sort it base on the date in a column. i initialized the datatable, it gets error when i set the column type as datetime, maybe i should just set it to string ? how do i achieve what i want to do ?