How to report on workers with termination date in last two months

Summary:

Content (required):

I'd be grateful for some help with a filter on an OTBI report. The report is quite basic, showing employee name, person number, position, location, department, manager and termination date. I want to display only workers with a termination date within the last 2 months from current date but can't find a way to do it.

The closest I got (meaning the only time it didn't error on me!) was with: "Workforce Management - Worker Assignment Real Time"."Worker"."Termination Date" BETWEEN (current_date-30) and (current_date+30). However this actually only pulled future dated termination dates through into the report, there were none displayed for the last 30 days and I don't understand why.