Unanswered

How to set a due date for the last day of the month (regardless of how many days in the month)

(0) Share

Report

Posted on by Hazzer

I'm very new to Power Automate so I'm hoping this is going to be pretty simple to answer. I have several flows setup that create tasks in Planner and assign an appropriate due date. Some of these tasks need to be generated in planner at the start of each month and assigned a due date of the last day of the month.

I know how to set the due date for (for example) 30 days from the start of the month but obviously that doesn't really help.

Appreciate some help please.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

Hello,

You can leverage the startofamonth function and then substract one day so that you get the last day of the previous month, somehting like that
addDays(startOfMonth('NextMonth'),-1,'MM-dd-yyyy')

Best regards,
Alaa

Was this reply helpful? Yes No
Hazzer 4 on at

Like (0)

Report

That's great, thanks for your help.
Hazzer

Was this reply helpful? Yes No
Hazzer 4 on at

Like (0)

Report

Hello

The above worked for me when I set this up and tested it last month but now it's failed....

Any ideas why please?

Thanks

Was this reply helpful? Yes No
jgoldstein3 26 on at

Like (0)

Report

The below expression worked for me to get that day of the month!

addDays(addToTime(startOfMonth(utcnow()),1,'Month'),-1,'yyyy-MM-dd')

Was this reply helpful? Yes No