Filter Excel date

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? :pray:

@Max_S, which is the exact problem you have? :slight_smile:

@Max_S,

Is this what you need?

image

HI @Max_S

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

Regards
Gokul

1 Like

(post deleted by author)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.