I need to filter one year and one month before date in excel sheet from current date. I tried so many ways, but it can,t work. If anyone knows how to do that, please share with me

Help Studio
, ,
4

HI @lokeshkumar.k

You can Try with LINQ expression

DtOutput → System.data.DataTable

DtOutput = DtreadFull.AsEnumerable.Where(Function(x) Not(String.IsNullOrWhiteSpace(x("Column Name").ToString)) AndAlso (CDate(x("Column Name").ToString)<(new DateTime(Now.Year,Now.Month-12,1)))).ToArray.copytodatatable

Regards
Gokul