Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Configure scheduler to run the last day of the month in ACS

Avatar

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

24-09-2018

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.

1578477_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

25-09-2018

Hi,

ACS doesn't 't support the last day of the month in the schedule.

all you can do is

1. Run/schedule your scheduler every 28th day of the month

2. Use enrichment to get the lastday of the month as additional data

i.e. SubMinutes(AddMonths(YearAndMonth(GetDate()), 1), 1)

3. Check >In split if your lastdaydate is equal to today's date yes? proceeds to your main task else go for one day wait in wait activity and check again next day in same split.

Regards,

Amit

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

30-09-2018

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

1582480_pastedImage_3.png

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Garima_Gakhar
Employee

24-09-2018

Hi anasso83525035

In case of ACC, you need not worry about the value. It automatically calculates the Last day of the month, you will notice this when you click on Next after the step highlighted above.

1578515_pastedImage_0.png

In case of ACS, I am not sure if keeping a value of 31 would help in case of months having last day as 30/February.

You could try that once and see if it works.

Avatar

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

24-09-2018

Thanks for your answer, but what will happen then if i keep the 31st day configuration ?

Will it run on the 30th of september for example ?

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Garima_Gakhar
Employee

24-09-2018

Hi anasso83525035

This is not available within ACS. We can check on this further with the Product Team on our side.

In ACC this is allowed as per the "Last day of the month" option:

1578502_pastedImage_0.png