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

Help Activities
, , , ,
1

Hello,

Greetings,

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.

Regards,
Mayank Mehta.

2

Hi @Mayank_mehta

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

3

Hi prasath,

its resolved thanks man.

:slight_smile: