Matching dates Using Linq Query

I have excel
image
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

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

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

greater than user date

Thanks in advance

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 :

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.

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