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.