How to filter out the records in datatable for particular column having dates older than last 90 days?

[BTanaji]

I have one datatable with 2000+ records. these records are for the users who logs in the system. it contains one column as “Last logon” having the dates in format “MM/dd/yyy”. I want to filter out the records in “Last Logon” column which are older than 90 days. (something like todays date - 90 days)

[Parvathy (PS Parvathy)]

Hi @BTanaji

Try this linq expression:

filteredData = YourDataTableVariable.AsEnumerable().Where(Function(row) DateTime.ParseExact(row("Last Logon").ToString(), "M/d/yyyy", System.Gobalization.CultureInfo.InvariantCulture) >= DateTime.Today.AddDays(-90)).CopyToDataTable()

filteredData is of DataType System.Data.DataTable

Hope it helps!!

[ppr (Peter Preuss)]

we keep in mind:

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", CultureInf…

Assign Activity:
dtFiltered =

(From d in YourDataTableVar.asEnumerable
Let dp = DateTime.ParseExact(row("Last Logon").ToString(), "M/d/yyyy", System.Gobalization.CultureInfo.InvariantCulture)
Where dp.Date < DateTime.Now.AddDays(-90).Date
Select r =d).CopyToDataTable

As mentioned above within the FirstAid we check the DataTable and align the DateTime parsing accordingly

Handling empty results:

[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.AsE…

Feel free to adapt the LINQ e.g. by handling empty row values / non parseable values etc