Dataform period roll back to 6 month from current period

Summary:

The customer needs to view financial data for the previous six months relative to the current period. They want this to update automatically without requiring manual adjustments each month. We attempted to use a substitution variable, but it fails when the period crosses into a new year, so it doesn’t meet the requirement. Can this be automated using form functionality?

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):