Answered

formatDatetime giving wrong month

(0) Share

Report

Posted on by TR-23071229-1

I have a flow variable to find the first day of the previous month which gives me the correct date (but it adds a time) I want to format the date to be mm-dd-yy

addtoTime(startOfMonth(addToTime(utcNow(),-1,'month')),0,'day')

value = 2020-01-01T00:00:00.0000000Z

When I add formatDateTime to the variable it gives me a wrong month

formatDateTime(addtoTime(startOfMonth(addToTime(utcNow(),-1,'month')),0,'day'),'mmmm-dd-yyyy')

Value = 00-01-2020

Any help would be appreciated

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RobElliott 10,450 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

@trentskirush in Power Automate the month part of the expression must always be in upper case, i.e MMMM. Lower case is used for minutes.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
TR-23071229-1 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott- thanks - I was thinking that might be it, but never got around to trying that. thanks for the clarification.

Was this reply helpful? Yes No