web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / getting date format MM...
Power Automate
Answered

getting date format MMM yyyy

(0) ShareShare
ReportReport
Posted on by 165

Hi, please, i need help in getting an expression that would output Last month and current year. example: February 2022.

Thank you

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @damiosiks 

    Here ya go.....

    formatDateTime(utcNow(),'MMMM yyyy')
    image.pngimage.png
     
     
  • damiosiks Profile Picture
    165 on at

    How about February 2022? this solution provides for March which is current month

  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @damiosiks 

    The expression that I provided will give you the month and year for the current date.  If it were February, it would result in February 2022.

    Do you want the result always to be 1 month back?  If so, then use this expression:

    addDays(startOfMonth(utcNow()),-1,'MMMM yyyy')
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 450

#2
Haque Profile Picture

Haque 366

#3
Valantis Profile Picture

Valantis 349

Last 30 days Overall leaderboard