Something about the filtdata datable

Help Studio
,
1

output_test.zip (39.7 KB)

hi, who can help me figure out this example?thanks in advance.

2

an you tell me abt scenario?

3

I want to copy a data excel to a new excel file,and filter this data ,if row(“due date”) is more than 60days from now ,then write these filter data to the “>60days” sheet,if 180 days,then write to the “>180days” sheet.i use the below expression to judge.

DateTime.Today - DateTime.Parse(row_2(“due date”).ToString)).Days >60