Filter excel

Learning Hub
1

Hi Team,
I have attached the excel. From the attached excel column “Successfully Reconciled Holding as of File Date”, i want all data which date has been greater than t(system date)-7.
And that data needs to be pasted in same excel but in different tab.
Original data also be present in excel.sush.xlsx (39.8 KB)

Pls help me out

Regards,
Sushant

2

If the Date column is of type “Datetime/Date” . You can use Filter datatable.

3

i have tried but its not working, thats why raise in a forum

4

Hi ,

Excel Filter date - Copy.xaml (9.1 KB)
Can you try using this.