How to Filter Date format column using filter datatable

[sachinns]

Hi,

Can someone help me to filter date (date format) column in my csv file.
i want to filter based on 2 days back data. so my filter variable will be like this Date.Now.AddDays(-2).ToString(“MM/d/yyyy”)

sample.zip (27.1 KB)

Thanks

[Palaniyappan (Forum Leader)]

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 @sachinns

[sachinns]

Thanks for the reference. But it didn’t worked for me. Can u please see my sheet and help me to create the workflow.

[Ramprasad (Ramprasad Jilla)]

@sachinns

After reading data, its showing as yyyy-MM-dd format

Try with Now.AddDays(-2).ToString(“yyyy-MM-dd”)

[sachinns]

Thanks Bro. It worked

Cheers