@Kevin M-Oracle now that's an idea/good option as well. 🤔 Thank you. I'll share this with the requestor. 😁

Thank you @Kevin M-Oracle, yes, I found that page. It looks like there isn't an existing "formula" for specific date. All of the ones listed have the +/- 1, 7, etc. #of days but that will not work for our needs since each month has a different number of days and we need the report to run monthly with a specific date for…

It is a publisher report, with a schedule report job. NOT an analysis.

The current/prior month is part of the report parameters. In the scheduled job it shows in the General tab. We have the schedule set to run on the 28th but we need the data to be as of the 28th of the current month and the 28th of the prior month.