About Data Table filtering Date

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.

image

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

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

Regards,
NaNi

1 Like

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

1 Like

image

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

Hi Thiru,

Already check, yes the data is presented in Column

Hi!

Have a view on this thread

Regards,
NaNi

Hi @Likesh_Lim

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

image
Hi Robin,
Nope, this is the output.

Hi Nani,

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

Can you share your input excel

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

1 Like

Hi Robin

This is the Excel input
image

This is the posting date column format

Hi Tandon,

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

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 …

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

1 Like

Hi Mahanthi

I hit this error

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

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)

1 Like

Hi @Likesh_Lim

replace the equals sign into Contains
image

now the filter condition works perfectly

hope it solves your issue

Thanks,
Robin

1 Like

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

1 Like