Linq query to filter data with today's data

[Sneha_1992 (Sneha)]

I have a data table and it has multiple columns and rows in it but I need to filter column A with todays date and add this row as queue item

[mkankatala (Mahesh Kankatala)]

Hi @Sneha_1992

You can use the LINQ Expression for this.

Follow the below steps,
→ Use the Read Range workbook activity to read the excel and store in a datatable called DT.
→ Then use the assign activity to write the LINQ Expression,

- Assign -> TodaysDate_DT = DT.asenumerable.where(Function(x) CDate(x("ColumnA").toString).equals(DateTime.Now)).Copytodatatable()

→ Then use the Bulk add queue items activity and give the TodaysDate_DT as input to it, it will add the rows in TodaysDate_DT to the queues.

Hope it helps!!

[Yoichi]

Hi,

The following sample will help you.

arrDr = dt.AsEnumerable.Where(Function(r) CDate(r("column A").ToString).Date = DateTime.Today).ToArray()

Sample
Sample20240823-2.zip (9.5 KB)

Regards,

[Sneha_1992 (Sneha)]

Thank you for the quick response
\