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 Automate
Answered

Long Date Format

(0) ShareShare
ReportReport
Posted on by

Quick quesiton which I'd have thought wouldn't be that hard but has stumped me so far.

 

How do I format a date so it appears like: "1st Janurary 2019"?

 

Thanks,

Categories:
I have the same question (0)
  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @Lewkir 

    Hi there!  I think it's the ordinal indicator ('st') that's complicating things.  I don't think it's part of the standard, but it doesn't mean it's impossible.  Essentially, you'd want to break the date number off, look at the last digit and build a switch:

    If the last digit is a 1, then set the indicator to 'st'

    If the last digit is a 2, then set it to 'nd'

    If it's 3, then set it to 'rd'

    otherwise, set it to 'th'

    And then piece together the date as a concatenated string to present wherever you'd like.

     

    We can do all of this without code, or there's probably a way to do it with an expression or two.  What's your comfort level like?  Keep us posted.

     

    -Ed-

     

     

    If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

  • Verified answer
    v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @Lewkir ,

     

    Please try this format:

    d MMMM yyyy

    It seems that the date of the format "1st" is more complicated, and the use of numbers seems to basically meet your needs.

    74.PNG

    utcNow('d MMMM yyyy')
    formatDateTime('2019-07-01','d MMMM yyyy')

     

    Best Regards,

  • Lewkir Profile Picture
    on at

    Cheers, after re-reading the email I've realised I only needed the format 1 January 2019 so this will suffice.

     

    Thanks for your help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 607

#2
Valantis Profile Picture

Valantis 456

#3
11manish Profile Picture

11manish 352

Last 30 days Overall leaderboard