Hi All, I need to filter the excel and below is the criteria: Filter the records on Column A (Due Date) to contain the records with due date that are 7 days old. For example, if the current date is 11/05, select only the records with Due Date as 10/29. On Fridays, include records with due date 7…

@IshaSharma , Check the attached xaml, it may help you. Let me know if you need further details. FilterExcelByDateCol.xaml (7.9 KB)

Filter excel with dates

Palaniyappan (Palaniyappan P ) November 12, 2019, 9:56am 2

kindly have a view on this thread

Topic		Replies	Views
Can Someone help me with filtering excel column which has a date Studio uiautomation	10	987	March 28, 2022
Filter date column in datatable Activities datatable , excel	14	1703	September 26, 2021
Filter the column based on completed Studio studio , question , project_panel	43	1167	August 8, 2023
How Can I Filter Records Older Than 10 Business Days in the Table Help datatable , studio , question	9	1709	December 7, 2020
How to get the excel data from -7 days to -3 years from .xls file Studio studio , question , activities_panel	16	300	September 9, 2023