Reporting Prior Month Data SQL

Summary:

Can we add SQL to the formula to look at the Prior Month data?

So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prior month?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):