Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Display the current time to be the abbreviate of Month

(0) ShareShare
ReportReport
Posted on by 164

Hi Everyone,

 

I know how to use utcnow to make the current date as DD/MM/YY.......11/02/2020 with the expression @formatDateTime(utcnow(), 'dd-MM-yyyy')

But is it possible to make the date format as DDMMMYYYY, for example, 24OCT2019

 

Hope Flow can do this, thanks.

 

Regards,

ilu989

  • ilu989 Profile Picture
    ilu989 164 on at
    Re: Display the current time to be the abbreviate of Month

    Hi @efialttes ,

     

    Thanks for your instruction, that's work and amazing!

    @formatDateTime(utcNow(), 'ddMMMyyyy')

     

    Regards,

    ilu989

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Display the current time to be the abbreviate of Month

     

    Hi @ilu989 ,

     

    Please try the methods provided by @efialttes to achieve the requirements. I tested it on my side and this method fits your needs.

    120.PNG

     

    Best Regards,

  • Verified answer
    efialttes Profile Picture
    efialttes 14,756 on at
    Re: Display the current time to be the abbreviate of Month

    Hi

    According to the documentation formatDateTime() supports "Either a single format specifier or a custom format pattern. The default format for the timestamp is "o" (yyyy-MM-ddTHH:mm:ss:fffffffK), which complies with ISO 8601 and preserves time zone information."

     

    So, if we use custom format pattern, in theory it should be possible to request the following format

    formatDateTime(utcNow(), 'ddMMMyyyy')

     

    If you need it in capital letters, try with

    toUpper(formatDateTime(utcNow(), 'ddMMMyyyy'))

     

    Hope this helps

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics