Hi
i would like to filter the data by only currentdate and can just ignore the time from “Initiared On” Column.
Please suggest …
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
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…
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.