About Data Table filtering Date

[Likesh_Lim]

Hi,

i have Read Range from Excel and put into a DataTable, now i want to use the Filter Data Table activities to filter out the Date.

But it can’t work, the output data table still 0.

[THIRU_NANI (NaNi)]

Hi!

Could you please check if that row is present in that particular column or not!

and also have a view on this docs about filter data table

https://docs.uipath.com/activities/docs/filter-data-table

Regards,
NaNi

[pravin_calvin (pravin kumar)]

Hi @Likesh_Lim

Check With the Date format coming out from the excel and then use the filter condition !

Use For each row and print the date column and use the format in filter datatable!

Regards

[Likesh_Lim]

Hi Calvin, i have check, and i put as “10/03/2021 00:00:00”, but still return 0 row

[Likesh_Lim]

Hi Thiru,

Already check, yes the data is presented in Column

[THIRU_NANI (NaNi)]

Hi!

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…

Regards,
NaNi

[Robinnavinraj_S]

Hi @Likesh_Lim

Can you check whether the input date contains any other extra white spaces

[Likesh_Lim]

Hi Robin,
Nope, this is the output.

[Likesh_Lim]

Hi Nani,

So meaning there’s no way to using the Filter Activities to do it?

[Robinnavinraj_S]

Can you share your input excel

[Shikhar_Tandon]

Hi @Likesh_Lim ,

You can convert the date format and remove the trailing Zero’s and then apply a filter, this would give you the results.

Thanks,
Shikhar

[Likesh_Lim]

Hi Robin

This is the Excel input

This is the posting date column format

[Likesh_Lim]

Hi Tandon,

Did you mean change in the excel or the datatable? is there any example that converting datatable column format directly?

[Robinnavinraj_S]

Hi @Likesh_Lim

Actually we need your excel file so that only we can figure out where the issue came from

Can you share your excel file with dummy data …

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @Likesh_Lim ,

instead of filter data table activity you could use the below expression assign activity and store the result into another data table ad check if you are getting correct output. please try and let us know. thanks.

FinalDatatable = YourDatatable.Select(“[Posting Date] = ‘10/03/2021’”).CopyToDataTable

[Likesh_Lim]

Hi Mahanthi

I hit this error

[Likesh_Lim]

BankStatement_Dummy.xlsx (23.6 KB)
Hi Robin, as requested, thanks for the help

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @Likesh_Lim ,

Could you pls add single quotes manually in your studio instead of copy the expression some times copy from the forum making some different quotes. just use suggestion from my expression but manually write double quote and single quote in studio assign activity to resolve the issue. Find the attached work flow for your reference. thanks.

FilterDemo.zip (2.3 KB)

[Robinnavinraj_S]

Hi @Likesh_Lim

replace the equals sign into Contains

now the filter condition works perfectly

hope it solves your issue

Thanks,
Robin

[Likesh_Lim]

Thanks everyone for the help and Suggestion, appreciated =)
Robin Solution works, just change to “contains” .
But still , thanks for others helping too