web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : zQQy51FO4+KkZfsaaIdIHk
Power Platform Community / Forums / Power Automate - General Discussion / Various ways to format...
Power Automate - General Discussion
Answered

Various ways to format date in long formats

Like (2) ShareShare
ReportReport
Posted on 27 Mar 2024 22:02:20 by CodeAvenue 103

Dropping this here for someone starting out with Power Automate and having a hard time finding the right way to format dates.

* Get the year:

formatDateTime(triggerOutputs()?['body/start'],'yyyy')

Equals 2024

 

* Get the month:

formatDateTime(triggerOutputs()?['body/start'],'MM')

formatDateTime(utcNow(),'MMMM') which gives the result August.
so MM=08, MMM=Aug, MMMM=August

 

*Long format date

formatDateTime(triggerOutputs()?['body/start'],'MMMM dd, yyyy')

Equals March 27, 2024

 

*Get day of the week

formatDateTime(triggerOutputs()?['body/start'],'dddd MMMM dd, yyyy')

Equals Wednesday March 27, 2024

  • Verified answer
    CodeAvenue Profile Picture
    CodeAvenue 103 on 07 Aug 2024 at 19:07:10
    Various ways to format date in long formats
     

    Dropping this here for someone starting out with Power Automate and having a hard time finding the right way to format dates.
     

    * Get the year:

    formatDateTime(triggerOutputs()?['body/start'],'yyyy')

    Equals 2024

     

    * Get the month:

    formatDateTime(triggerOutputs()?['body/start'],'MM')

    formatDateTime(utcNow(),'MMMM') which gives the result August.
    so MM=08, MMM=Aug, MMMM=August

     

    *Long format date

    formatDateTime(triggerOutputs()?['body/start'],'MMMM dd, yyyy')

    Equals March 27, 2024

     

    *Get day of the week

    formatDateTime(triggerOutputs()?['body/start'],'dddd MMMM dd, yyyy')

    Equals Wednesday March 27, 2024

  • Chriddle Profile Picture
    Chriddle 7,932 Super User 2025 Season 2 on 28 Mar 2024 at 08:25:59
    Re: Various ways to format date in long formats

    There's a bit more to it (e.g. locale, single format specifier)

     

    To learn the basics I recommend to start here:

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft on 28 Mar 2024 at 01:07:50
    Re: Various ways to format date in long formats

    Hi, @CodeAvenue 

    Thanks for sharing on the date format! You can use your own reply Mark as a solution, which can help more people!

     

    Best Regards,

    Yueyun Zhang

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans