Report Absence based on rolling 12 months from start of month

Summary

How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm in

Content

Hi

I would like to report absence on a rolling 12 months but not from today.  I need the report to show from the beginning of the month.

So for example, if I'm in September 2020 and today is 22nd September 2020, I want to show the rolling 12 months from 1 October 2019.

At the moment, the report is showing a 12 month period from 22nd October 2019 and excludes the beginning of October's absence.

Thank you.

Version

20B

Code Snippet

TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE)