Need to filter previous date

I have.a requirement to filter previous date i have around 2400 data which ran yesterday.but when i used filter activity now.adddays(-1).to string(MM/dd/yyyy) its filtering only 1000 data

Hi @sruthesanju ,

Could you let us know what was the Activity used to Filter ?

Filter data table

Hi @sruthesanju

May the date format is not matched for those which is not filtered try this

Assign a datatable variable FilteredDt=

DT.AsEnumerable().Where(Function(a) DateTime.ParseExact(a("ColumnName").ToString,{"MM/dd/yyyy hh:mm:ss","dd.MM.yyyy","dd/MM/yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy").Equals(Datetime.Now.AddDays(-1).ToString("dd.MM.yyyy"))).CopyToDataTable

FilteredDt will have the output check and let us know

Regards
Sudharsan

Regards
Sudharsan