dear all, i have read range the following excel table into a DT. i need to now filter the read DT by date. however it is not working. hope to you get your help. many thanks
if You Want Today’s Date Data Then use this Query :
DT.AsEnumerable.Where(Function(r) DateTime.ParseExact(r(0).ToString,“dddd,dd MMMM yyyy”,System.Globalization.CultureInfo.InvariantCulture).Date=Now.Date).CopyToDataTable
Can you share the variable you used while filtering?
First read excel and share format of date field in your datatable from locals field.
Then let’s try to write a filter suitable for this format in the filter field.