Hi Guys, i have some understanding Problems with my application.
I want to filter columns from my Excel Table. If the a date in my Excel column is older as 6 months i want to copy the Column and paste it in a second Excel file.
I already got the Assign Value to filter 6 Months in the past (DateTime.Now.AddMonths(-6).ToString("dd.MM.yyyy“))
Can anyone Help me with this Problem pls?
@Max_S, which is the exact problem you have?
Welcome to community
Try this expression
DtMaster.AsEnumerable.Select (Function(x) x("ColumnNameOrIndex").ToString.Trim.Equals(DateTime.Now.AddMonths(-6).ToString("dd.MM.yyyy"))).ToArray()
Have a look on it for more info
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.