Filter Datatable always returnong blank

Hi UiPath,

I need help with my problem.

I have an excel file data attached:

Report.xlsx (10.2 KB)

I’m saving it to a datatable variable,

and use filter datatable activity to keep only the row/rows that is equal to today’s date.

I tried the following below: but the filter datatable activity is only returning blank collection.

Hope someone can help me or atleast lead me to the right direction.

thanks!

Hi @alvin.c.apostol26 instead of (=) use contains.

also try “Bot Process date” = now.tostring(“MM/dd/yyyy”)

HI @alvin.c.apostol26

Try to give the format and check it

Now.ToString("MM/dd/yyyy")

image

Check out the XAML file

FilterTodays’sDate.xaml (9.2 KB)

Regards
Gokul

hi @alvin.c.apostol26

You can try with contains in the filter datatable

but before that please confirm the date Format in the datatable

Regards
Sudharsan