How to filter all the days older than a particular day in an Excel file

Help Activities
, , , ,
1

Hi guys, I need help in this for example 01/04/2024 this is a day which is six months back from today, I want to filter all the days which is older than this 01/04/2024 particular day in a excel file, how to do it. Suggest a linq expression for it

2

@Gopi_Krishna1

say data is in dt

then use in assign dt = dt.AsEnumerable.Where(function(x) Cdate(x("ColumnName").ToString) <= Now.AddMonths(-6)).CopyToDatatable

cheers