cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ajaykumar11111
New Member

date conversion in power automate desktop

HI i have a date  19/6/2021  to be convert into 6/19/2021 in power automate desktop. can anyone help?

thanks in advance.

1 REPLY 1
shindomo
Continued Contributor
Continued Contributor

Hello @ajaykumar11111,

 

Here is an example of convert date format from 19/6/2021 to 6/19/2021.

 

shindomo_0-1632050825586.png

 

shindomo_1-1632050837927.png

 

 

SET OriginalDate TO $'''19/6/2021'''
Text.ToDateTimeCustomFormat Text: OriginalDate CustomFormat: $'''d/M/yyyy''' DateTime=> TextAsDateTime
Text.FromCustomDateTime DateTime: TextAsDateTime CustomFormat: $'''M/d/yyyy''' Result=> FormattedDateTime

 

 

Thanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,304)