Get last day of the current month

(0) Share

Report

Posted on by Amit_Chaudhary

Hi Team,

How to get last day of the current month in power automate desktop?

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Mowgli 15 on at

Like (4)

Report

You could do something like this. (It's something that I used a long time ago)
(Paste it into Pad)

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''dd''' Result=> FormattedDateTime
Text.ToNumber Text: FormattedDateTime Number=> TextAsNumber
DateTime.Add DateTime: CurrentDateTime TimeToAdd: $'''-%TextAsNumber - 1%''' TimeUnit: DateTime.TimeUnit.Days ResultedDate=> Firstdate
DateTime.Add DateTime: Firstdate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> LastDate
DateTime.Add DateTime: LastDate TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> LastDayInMonth
Display.ShowMessageDialog.ShowMessage Message: $'''First date of Month : %Firstdate%
Last date of month : %LastDayInMonth%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed

Was this reply helpful? Yes No
darshi_khirani 2 on at

Like (0)

Report

Hi Mowgli I am struggling to get this but I didnt understand what to do
I want the first date of current month and the last day of the current month

how do i get these two answers i saw you answer but i didnt understand where to paste the text

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Just paste it directly into the PAD flow designer and the actions will be automatically created for you.

Was this reply helpful? Yes No
Suggested answer

CALEBHOWARD80 27 on at

Like (1)

Report
To solve this, you can break down the formula by focusing on the equals statement. Here’s how it looks:

addDays(addToTime(startOfMonth(utcNow()), 1, 'Month'), -1)

Explination:

startOfMonth(utcNow()) - Gets the start of the current month.

addToTime(..., 1, 'Month') - Moves to the start of the following month.

addDays(..., -1) - Backs up by one day, giving you the last day of the current month.

/////////////////////////////////////////////////////////////////////////////////

I designed this formula to check if today is the last day of the month, but you can adapt it to check any day you want by changing -1 to the number of days from the end of the month you're interested in.

Here’s the formula:

equals(startOfDay(utcNow()), addDays(addToTime(startOfMonth(utcNow()), 1, 'Month'), -1))

Explination:

startOfMonth(utcNow()) - Finds the start of the current month.

addToTime(..., 1, 'Month') - Moves to the start of the next month.

addDays(..., -1) - Backs up one day, giving you the last day of the current month.

equals(startOfDay(utcNow()), ...) - Checks if today is that date.

For any other day near the end of the month, just adjust -1 to a different number.

Let me know if you’d like more detail!

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

try this out:

CurrentDateTime = DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime

FormattedDateTime = Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: "dd"
TextAsNumber = Text.ToNumber Text: FormattedDateTime

FirstDate = DateTime.Add DateTime: CurrentDateTime TimeToAdd: -TextAsNumber + 1 TimeUnit: DateTime.TimeUnit.Days

LastDate = DateTime.Add DateTime: FirstDate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months
LastDayInMonth = DateTime.Add DateTime: LastDate TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days

Display.ShowMessageDialog.ShowMessage Message: "First date of Month : %FirstDate% \nLast date of month : %LastDayInMonth%"

Was this reply helpful? Yes No