A complete rookie here and i have seen threads discussing similar issues in forum but couldn’t workout a solution that i could use.
I am working on an automation where I am trying to create a report showing documents that are due (dates older than today) and that are due in next 15 days. But the parent excel has some rows which has dates that are older than 15 days and i need to remove those rows from the new datatable. I am currently taking out the data from parent excel using read range. I tried using filter datatable and also tried using a while loop as you can see in attached image. Please also find the attached parent excel and final report. You can see that the final report has some dates still remaining which are higher than 15 days from today. Couldit be because the filter datatable or while loop was unable to recognise the dates in datatable? Please help me.
Final report.xlsx (11.5 KB) Parent excel.xlsx (11.3 KB)