Deleting the record which do not fit in between the range

Help Studio
, ,
3

Hi @Kunal_Jain

How about the following?

image
image882×636 35.5 KB

Code:

DT1.AsEnumerable() _
    .Where(Function(row) DateTime.Parse(row("Due Date").ToString()) > currentDate.AddDays(-30) AndAlso _
                        DateTime.Parse(row("Due Date").ToString()) < currentDate.AddDays(21)) _
    .CopyToDataTable()

BlankProcess14.zip (71.5 KB)

O/P:
Sample (3).xlsx (11.3 KB)

Hope this helps!!