Answered

Monthly tasks Starting on Monday

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi there,

I have recurring tasks that occur the first Monday of each month and end that same Friday. How would i go about setting the start and end dates, is there an expression or would i need a complicated formula? The ones i have found either dont seem to work, or are complicated formulas that give sunday to saturday results.

Thanks,

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (1)

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous set the schedule to week and on every monday-friday add a trigger (menu select settings + add trigger) in the trigger add your code to evaluate (@less(int(utcNow('dd')),8)).

Steps

Interval: 1

Frequency: week

Timezone: whatever you need

On these days, mon,tues...,fri

Setting add trigger

That should do it,

R

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response, i should have mentioned this is to create a Planner task including a start and end dates. *I tried anyways, and it did not give me either start or end date.

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous do you want the schedule to create a task on the first Monday with the start date as that Monday and the end date that Friday?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, the task would be created the first monday of the month, with a start day and end day of that week. For example, it would create a Planner task for May on the 2nd (a monday) with a start day of the 2nd (monday) and a finish day of the 6th (friday). Then for June, it would be the 6th (monday) and the 10th (friday). Thank you!

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

ok @Anonymous got it.

Schedule as before bu this time only add the Monday.

Steps

Interval: 1

Frequency: week

Timezone: your timezone

At these hours: your hour

At these minutes: your minutes

Settings

Trigger Conditions: @less(int(utcNow('dd')),8)

The add a Planner steps

Group ID: yours

Plan Id: yours

Bucket: if you wish to set one

Start Date Time: an expression utcNow()

Due Date Time: an expression addDays(utcNow(),7)

That will do it.

Try it now with the following example

This will create a task as you wish.

hope it helps,

R

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Ok thanks, i thought the second part would be more difficult. But i assume that if it creates the task on the desired day (mondays only) and it runs only on the first of the month, which is set in the Recurrence trigger, then the planner portion is simple. Thank you! Now to wait to see if it works. Will return to this thread in May.

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous I noticed I asses 7 days, you will need 5. addDays(utcNow(),5)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks @rubin_boer , i think i get how this all works, now i was wondering how i could specify something like the 3rd Monday in a month. Similar to the initial request, this task would repeat every month, but i would like the task to start on the third Monday in the given month, for example, it would be the 18th of April, then again the 16 of May. would it be the same except the trigger condition would specify a less than and a greater than value?

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
hi @Anonymous

consider the:

first specific day trigger (@less(int(utcNow('dd')),8))

last specific day trigger (@greater(int(utcNow('dd')),24))

second specific day trigger (and(@greater(int(utcNow('dd')),8)),(@less(int(utcNow('dd')),16)))

third specific day trigger (and(@greater(int(utcNow('dd')),16)),(@less(int(utcNow('dd')),24)))

Hope it helps,

R

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Great, thank you, this makes sense!

Was this reply helpful? Yes No