Hi
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))
Regards
Nived N
Happy Automation
2 Likes
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
thanks much @NIVED_NAMBIAR
Main (1).xaml (7.7 KB)
Hi @NIVED_NAMBIAR ,
Im still getting this error. but the datatble has rows in it…
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
Regards,
Nived N
Happy Automation
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.