Date Time Format change and comparison

Hi @ankush.jeengar ,

Could you maybe also try with the below Expression :

FilteredDT = DT.AsEnumerable.Where(Function(x) DateTime.ParseExact(x("Your Date Column").ToString,"dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).Date < Now.Date).CopyToDatatable

Here, DT is the Input datatable read from Excel sheet, FilteredDT is the Output Datatable after filtering.

Also for handling the error on direct CopyToDatatable, refer the post below :

Let us know if you are still facing issues.