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 / How to convert "Mon Ja...
Power Automate
Answered

How to convert "Mon Jan 01 2018 00:00:00 GMT+0000 (UTC)" to MM/dd/yyyy format in Power Automate desktop

(0) ShareShare
ReportReport
Posted on by 4

How to convert "Mon Jan 01 2018 00:00:00 GMT+0000 (UTC)" to MM/dd/yyyy format in Power Automate desktop.

 

or  Jan 01 2018  to MM/dd/yyyy format 

I have the same question (0)
  • Verified answer
    CristinaValdes Profile Picture
    65 on at

    Hi,

    You can split the text in two and just use "Mon Jan 01 2018 00:00:00", so with this text you can use the action 

    Convert text to datetime

    Converts a text representation of a date and/or time value to a datetime value.

     

    1.jpg2.jpg

  • NewPBIuser Profile Picture
    4 on at

    I was using text to datetime function instead of datetime to text function. Thank you so much 

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 507 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 267 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard