Configure scheduler to run the last day of the month in ACS
Hi,
How should I configure my scheduler to make sure it's runing the last day of every month, whether it's 30/31 days or 28/29 in February.
Will 31 as an N-th day do the job ?
Thank you.
Hi Amit_Kumar
Much thanks for your help.
Your answer helped me achieve the following solution for my need :
1. 4 Schedulers that will run monthly on the 28/29/30/31 days of the month.
2. Used my main query to add lastday of the month as an additional data :
@LastDayOfMonth = DateOnly(SubMinutes(AddMonths(YearAndMonth(GetDate()), 1), 1))
3. Check >In split if @LastDayOfMonth = DateOnly(GetDate()) yes? proceeds to send my delivery else end workflow
