Filter current date only

Hi @Henson_Ibon ,

It does look like all of your values are in one format, but if there are possibilities that an Empty value would be present in the Date, then we could use the below Expression :

FilteredDT = DT.AsEnumerable.Where(Function(x)Not String.IsNullOrWhiteSpace(x("appointmentdate").ToString) andAlso CDate(x("appointmentdate").ToString).Date=Now.Date).CopyToDatatable

For Handling of direct CopyToDatatable, you can check the below post :