How to Filter data table from specific time given?

[supermanPunch (Arpan)]

Hi @punya ,

Could you try the Below Linq Query using Assign Activity :

arrayRow = DT.AsEnumerable.Where(Function(x)CDate(x("Posting Time").ToString)>new DateTime(CDate(x("Posting Time").ToString).Year,CDate(x("Posting Time").ToString).Month,CDate(x("Posting Time").ToString).Day,16,0,0)).ToArray

Here, DT is the Datatable variable read from the Excel Sheet using Read Range Activity, arrayRow is a variable of type Array of DataRow.

Follow the Post Below to Convert Array of Rows / List of Rows to Datatable for Handling Exceptions.

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…