Filter datatable that has an excel date

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

Hi @Teck_Hwee_Goh,

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.

Regards,
MY