I want to filter out dates that aren't within the previous month

I am working on a robot which will have dynamic data coming in and I need to filter out anything that was not raised (in ‘Opened’ column on example) in the last month.
So if I ran it in December, it would pull out anything from November and remove the rest.
If I ran it in January, it would pull out December and so on.

I am having trouble working out how best to do this.
Can anyone help?

Test.xlsx (27.2 KB)


Check these out… Assign the date to variable and subtract 1 month from the date?