Hello Team, We have Date column in the xlsx file in the format of yyyy-mm-dd , i need a solution to filter only the previous month data range. Example, if you are running flow in Feb it should filter Jan data and save in the excel writer node
Hi Madhu,
I have designed a simple flow to achieve this output. I have inserted a string manipulation node which runs inside loop to check and compare 2 column scenarios to consider current month name and previous month name.