Return MPY and MCY

[t0mato]

Hi,

What would the query function be to return Month Prior Year (current month in the previous year, example output "March 2020"), Month Current Year (current month in the current year, example output "March 2021")?

I'm hoping to use these calculations for a monthly, active report and utilize these for the Headers of the report.

Thank you!

[t0mato]

NEVERMIND! PLEASE CLOSE.