Maybe this will help clarify.
You're right — Job Queue’s "Next Run Date Formula" does not support true business day logic (i.e., excluding weekends or holidays). The formula CM+1D-1WD still treats all days as calendar days and doesn’t evaluate weekends as non-working days.
Your Options:
1. Use a custom codeunit in the Job Queue that includes logic to:
Calculate the last working day of the month using a custom calendar or work date logic.
Run only when TODAY = LastBusinessDay.
2. Set job to run daily, and have your logic exit immediately unless it’s the desired date (e.g., last weekday of the month).
3. If you want more control, consider using Power Automate or a scheduler outside of BC that has better calendar logic, and trigger BC via API.
Unfortunately, there’s no built-in date formula in BC that supports “last business day” or “working day before a date.”
Mark below checkbox to make this answer Verified if it helps you. Let me know if you want a sample logic for calculating last business day.
