Filter Datatable by current date

[Muthulakshmi_Thangamuthu (Padman)]

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

Please suggest …

[NIVED_NAMBIAR (NIVED N)]

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

[Muthulakshmi_Thangamuthu (Padman)]

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…

[Muthulakshmi_Thangamuthu (Padman)]

Active_Employee_Reg_report_28_Feb_2021_04_18_17.xls (27 KB)

this is the sample excel file

[NIVED_NAMBIAR (NIVED N)]

Hi @Muthulakshmi_Thangamuthu

Check this xaml file
Main.xaml (7.5 KB)

It is working fine

Regards

Nived N

Happy Automation

[Muthulakshmi_Thangamuthu (Padman)]

thanks much @NIVED_NAMBIAR

[Muthulakshmi_Thangamuthu (Padman)]

Main (1).xaml (7.7 KB)

Hi @NIVED_NAMBIAR ,

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

[NIVED_NAMBIAR (NIVED N)]

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

Regards,

Nived N

Happy Automation