Scheduled Query- to automatically update date to pull data for
Hi
I have a scheduled query with a recurrence date of business day 1 to run every month.
This query should pull the prior month's data. For example, my queries run on Dec 2nd & I want it to pull all the data for the month of November. So each month I want the data to be pulled for the previous month on business day 1 automatically.
Currently, I have to remember to go in & update the date filter to pull the last most recent month. For ex. on Dec 2nd, I had to update my dates from 10/1/2024-10/31/2024 to 11/1/2024-11/30/2024, prior to the report being generated.