Get the date (YYYY-MM-DD) for the first monday of the month

Like (0) Share

Report

Posted on 31 Oct 2023 11:02:11 by rhagglund

Hey!

I'm trying to create a simple rule that will give me the date of the next "first Monday of the month" in the format YYYY-MM-DD, I've tried a number of different strings but can't get it to work...

Any suggestions? 🙏😊

All responses (4)

Answers (1)

rhagglund 25 on 31 Oct 2023 at 12:52:10

Like (0)

Report

Re: Get the date (YYYY-MM-DD) for the first monday of the month

Yes, it seems to work, thank you! 🙂

NO my next problem is that it is in english and not in swedish.... 😬
Verified answer

grantjenkins 11,059 Super User 2025 Season 1 on 31 Oct 2023 at 12:36:27

Like (1)

Report
Re: Get the date (YYYY-MM-DD) for the first monday of the month

I'm sure someone on this forum has a more streamlined solution, but this seems to work. You can specify whatever format you like - I just used 'dddd dd MM yyyy' so it showed the actual day Monday.

addDays( startOfMonth(addToTime(utcNow(), 1, 'Month')), mod(sub(8, mod(dayOfWeek(startOfMonth(addToTime(utcNow(), 1, 'Month'))), 7)), 7), 'dddd dd MMM yyyy' )
rhagglund 25 on 31 Oct 2023 at 12:34:02

Like (0)

Report

Re: Get the date (YYYY-MM-DD) for the first monday of the month

Yes, my bad....

I mean the first monday of next month 🙂
grantjenkins 11,059 Super User 2025 Season 1 on 31 Oct 2023 at 12:26:26

Like (0)

Report

Re: Get the date (YYYY-MM-DD) for the first monday of the month

Did you mean the first Monday of next Month?