Filter Datatable by current date

i would like to filter the data by only currentdate and can just ignore the time from “Initiared On” Column.


Please suggest …

Hi @Muthulakshmi_Thangamuthu
U can filter the excel by date as follows

dt1 = dt1.AsEnumerable().Where(Function(row) row(“Initiared On”).ToString.Contains(Now.ToString(“yyyy-MMM-dd”)).CopyToDataTable

where the dt1 is the datatable obtained by read range

Or u can use filter datatable activity to filter the column

“Initiared On” Contains CDate(Now.ToString(“yyyy-MMM-dd”))

(while read range (Check the preserve format option))


Nived N

Happy Automation


Hi @NIVED_NAMBIAR Thanks for ur suggestion.

I tried using the filter data table activity but its not returning anything…

on the other hand the assign activity throws an exception like the "Datatable does not have datarow…

Active_Employee_Reg_report_28_Feb_2021_04_18_17.xls (27 KB)

this is the sample excel file

Hi @Muthulakshmi_Thangamuthu

Check this xaml file
Main.xaml (7.5 KB)

It is working fine


Nived N

Happy Automation

thanks much @NIVED_NAMBIAR

Main (1).xaml (7.7 KB)


Im still getting this error. but the datatble has rows in it…

Hi @Muthulakshmi_Thangamuthu

I thinks there is no rows which had todays date

I checked it and i added a record with today.s date and was working fine

Kindly check ur excel file regarding this


Nived N

Happy Automation

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.