I need to filter a report at the end of every month but i only need the data from the start of the month to the end of the month. So could anyone guide me on the code to put into the advanced editor under the filter function?
Here is a scenario for better illustration:
On the 31st of July, I need to filter the report to only view the data from 1st to 31st July.
Subsequently, in the month end of 31st August, I need to filter the report to only view from 1st August to 31st August.