Need to prepare monthly report

Other SQL Server Topics
1

Hello Experts:

Every month, I'd want to send a report.

I have to manually alter the where clause's from and to dates each month.

Exists a way to automate this task? Help me with this request, please.

For instance, where ORDER_DATE is between 20230601 and 20230630.

I'm grateful.
Yoga

2 
WHERE order_date >= DATEADD(month, DATEDIFF(month, '1900', CURRENT_TIMESTAMP) - 1, '1900')
	AND order_date < DATEADD(month, DATEDIFF(month, '1900', CURRENT_TIMESTAMP), '1900')