Filter Data Table with dates as "Current month - 1"



I am trying to filter the data table where;

Excel Format is: 02-Feb-2021,
Robot reads the excel as: mm/dd/yyyy.

I want to filter excel as “current month - 1” and want previous month data to be left in my excel sheet.

After Filter data required in sheet: “current month -1”

Thanks in advance.

Mayank Mehta.

Hi @Mayank_mehta

Can you show the excel and show what is the input and what is the expected output…thanks

Hi prasath,

its resolved thanks man.