Filter date less than a specific date with excel sheet

[Lau_Wei_Ting]

Hi, I have a list of dates in the excel sheet and I want to filter the pass 6 months’ date starting from now.
How should I do it?
time.xlsx (473.8 KB)

[Palaniyappan (Palaniyappan P)]

Hi
Kindly have a view on this thread

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

Cheers @Lau_Wei_Ting

[Lau_Wei_Ting]

Hi, I had read the above attachment, however, I still did not get it
can u explain to it further??

[Palaniyappan (Palaniyappan P)]

Hi
Did we refer to the xaml in that solution post
There they are using Select method and filter the datatable with datetime passed a string variable
Cheers @Lau_Wei_Ting

[Lau_Wei_Ting]

Hi, for the past few days I have been trying the attachment and I get this error

may u assist me with this ?

[Palaniyappan (Palaniyappan P)]

It seems like the activity at which this error occurred has variable with null value
Kindly check that once
Cheers @Lau_Wei_Ting