Share
ReportHello,
I am looking to create a function that will filter an excel sheet based on some date criteria and am looking for the best method to approach this. I have an excel sheet that has dates and I would like to filter the table to include only the current month and the next month. My thought is I can achieve this by using a filter array block along with an expression to convert the value to an integer of only the month and then compare it to a variable I create based on the current date.
The two issues I have is how to include 2 months and I think I can get around this by using 2 filter blocks even though I would prefer to use one and the other issue is the fact that when I want to compare values within the table I cannot choose the specific column I want to look at and instead can only choose body or value from the excel sheet. I have included a screenshot of the current state of the flow.
Any suggestions or support are appreciated!
Thanks,
Ryan
All responses (
Answers (
345
