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

Notifications

Announcements

Community site session details

Community site session details

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

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,270 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,270 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard