Matching dates Using Linq Query

[srujana13a5]

I have excel

user will give random date if given date available in start date column bot should fetch given date and next to that date using linq query

[kali]

assign:
filteredDT = yourDT.select(“Start Date >= '”+inputDate+“'”).copytodatatable

or
filteredDT =
(from r in yourDT.select()
where r >= inputDate
select r).copytodatatable

[srujana13a5]

greater than user date

Thanks in advance

[supermanPunch (Arpan)]

Hi @srujana13a5 ,

You Could also try with the below approach :

DT.AsEnumerable.Where(Function(x)CDate(x("Start Date"))>=CDate(InputDate)).ToList

Where InputDate is your Date in String format.

Follow below on Converting List of DataRows to Datatable :

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

If the Above doesn’t give you the Correct results, we would want to know what is the format of the Input Date that is being used.

[kali]

ok, i edited:=) should be good now, best of luck