20

The feature that was released allows users to use the date formula to define when to run the scheduled job - i.e. "CM+1D" in the 'Next Run Date Formula' field will schedule a report on the first day of the next month.


This feature is actually not useful if you're scheduling a report where you have to define a date filter - i.e. if you want to schedule an Income Statement to run on the 8th day of each month for the previous month's results.


If you use the date formula in the date filter, assume today is 14/06/2022 (DD/MM/YYYY), "CM-2M+1D..CM-1M" this will give the result "01/05/2022..31/05/2022" - this formula on the date filter doesn't recalculate. The same report will run every time it's scheduled to run. The expectation is that when this runs in July, I get the Income Statement for June, when this runs in August, I get the Income Statement for July, and so on. I don't want the Income Statement for May, every month which is what will happen because the date filter formula isn't recalculated.

STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team