Filter Datatable and find only rows with today's date in it

Help Activities
,
1

Hello all,

I have a datatable with a column that contains list of holidays during the year.
The cells in that column are all in the Date/Time format if you put them into excel.
I am trying to filter the table so that it would be able to only leave me with the row that contains today’s date.
I know how to do that if it was just text and use a string but I don’t understand how to get it from a date/time format cell.
Someone please help!

2

same way
Use Filter Datatable activity and use Condition as

image
image805×243 7.4 KB

For Ref
Test.xlsx (9.0 KB) Main.xaml (11.7 KB)

1 Like