I have to delete rows from Date column compare today date if older than one month then delete rows from sheet

Help Studio
, ,
1

I have to delete rows from Date column compare today date if older than one month date then delete rows from sheet

Input :

image
image152×223 1.51 KB

anyone

Thanks
shaik

2

@shaik.muktharvalli1,

Use this LINQ

YourDataTable = YourDataTable.AsEnumerable() _
    .Where(Function(row) Not IsDate(row("Date")) OrElse CDate(row("Date")) >= DateTime.Now.AddMonths(-1)) _
    CopyToDataTable()
3

@ashokkarale your LINQ Quary working fine but I have to delete unwanted rows (more than one month) from sheet

please help

thanks
shaik

4

@shaik.muktharvalli1,

You can write this filtered data into a new Sheet and just delete the existing or original one.