Format Date as Last Day Two Months Prior

(0) Share

Report

Posted on by kanha123_456

Hi ,

I want a required date . For example - if current month is january. I want to go back previous two months and get that last date

For example - If today is 3rd jan2025 going back two months and get last date will be 30th nov 2024

Can anyone please help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

David_MA 14,128 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Use this expression: formatDateTime(addToTime(utcNow(),-2, 'Month'),'MM/dd/yyyy') and replace "MM/dd/yyyy with your desired date format. Run today, the expression returns:

Was this reply helpful? Yes No
kanha123_456 43 on at

Like (0)

Report
Copy link

Link copied!

@David_MA can you please tell with the desktop action

For example if current month is jan2025 I want to go back two month i.e Nov2024 and get the last date of nov2024 i.e 30nov2024

Was this reply helpful? Yes No
Suggested answer

David_MA 14,128 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Getting the last day of the month two months ago can be done with this expression:

formatDateTime(addDays(addToTime(startOfMonth(utcNow()),-1, 'Month'),-1),'MM/dd/yyyy')

Run today, it returns:

I don't use Power Automate Desktop, so I cannot answer how to do this there. You would be better off posting your question in the Power Automate Desktop forum instead: Microsoft Power Platform Community Forum Thread

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please use this.

1. Get your current month first date- StartOfMonth(utcnow())

2. Get Previous month first date - StartOfMonth(StartOfMonth(utcnow()),-1,'yyyy-MM-dd'))

3. Then get previous to previous month last date- addDays(StartOfMonth(StartOfMonth(utcnow()),-1,'yyyy-MM-dd')),-1,'yyyy-MM-dd')

So you have to use point no 3 expression to get your desired date.

Was this reply helpful? Yes No