Remove or filter rows which are not of current year

[SunnyJha]

I have a datatable dt in which I have a column called Start Date along with other columns. Now the date format is “M/d/yyyy” in this start date column. I want to remove all those rows which are not of current year.
So if this year is 2024 then remove all other rows whose start date is anything else.

i/p dt:

o/p dt:

[ppr (Peter Preuss)]

dtFiltered =

(From d in dtData.asEnumerable()
Let dps = d("Start Date").toString.Trim
Let dp = CDate(dp)
Where dp.Year = 2024
Select r =d).CopytoDataTable

Also have a look here:

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

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