Share
Report
2When creating a Job Queue process, there is no way to indicate that the process should run on the last "Business" day of the month -
This is June of 2025. The last day of the month is 5/31 which is a Saturday.
I want the process to run on Friday - the last business day of the month.
The Formula I saw online was CM+1D-1WD – should give you Friday this month (5/30) – being that this month ends on a Saturday…
But….
CM (Current Month – or the last day of the month – 5/31 – which is Saturday).
+1D – (Plus 1 Day -which is Sunday)
-1WD (minus 1 Weekday – which should be 5/30 – or Friday)
But it gives 5/31 – which again is Saturday..
I data entered the formula, and it came up: (for the "Combine Shipments" job)
But….
CM (Current Month – or the last day of the month – 5/31 – which is Saturday).
+1D – (Plus 1 Day -which is Sunday)
-1WD (minus 1 Weekday – which should be 5/30 – or Friday)
But it gives 5/31 – which again is Saturday..
I data entered the formula, and it came up: (for the "Combine Shipments" job)
Same is true for example if I want to run something on the 15th - or the last business day before the 15th.
Any thoughts?
Categories:
All responses (
Answers (
