Answered

How to convert yyyy-MM-dd to MM/dd/yyyy in power automate desktop flow

(0) Share

Report

Posted on by aggneha9821

I am reading a date format value from Excel in yyyy-MM-dd format and I want to convert it to MM/dd/yyyy in my Power automate desktop flow . Could anyone please tell.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (2)

Sort by

Verified answer

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@aggneha9821
You can try the below approach:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
aggneha9821 52 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji @Hi , thanks for help but it's not working for me this method giving current date and time .It's not converting the particular date

For example -
I set a variable xyz = 2023-09-31
Now this date I need to convert in MM/dd/yyyy
But by ur method it's giving me current date

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hey @aggneha9821, looks like you got an answer, but always feel free to check out this article if you have any date issues:

https://www.linkedin.com/pulse/power-automate-desktop-pad-best-practices-part-1-date-michael-annis/?trackingId=DF7oDEysRd667Xya9izLDg%3D%3D

Regards,

Mike

Was this reply helpful? Yes No
aggneha9821 52 on at

Like (0)

Report
Copy link

Link copied!

@MichaelAnnis hi , did not get complete answer .below is problem statement
For example -
I set a variable xyz = 2023-09-31
Now this date I need to convert in MM/dd/yyyy

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

If your variable is text format yyyy-MM-dd, then you need to convert it back to a date variable before converting it back to a different text variable type:

SET EDLM_yyyymmdd_Dash TO $'''2023-09-31'''
Text.ConvertTextToDateTime.ToDateTimeCustomFormat Text: EDLM_yyyymmdd_Dash CustomFormat: $'''yyyy-MM-dd''' DateTime=> EDLM
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: EDLM CustomFormat: $'''MM/dd/yyyy''' Result=> EDLM_mmddyyyy_Slash

Good luck!

Was this reply helpful? Yes No
aggneha9821 52 on at

Like (0)

Report
Copy link

Link copied!

@MichaelAnnis thanks for reply , but this is the same method I tried before it's not working .In second action it's throwing error as the provided text value can't be converted into valid datetime

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@aggneha9821

Could you pls share your system date time format for our reference? Screenshot would be preferred

Was this reply helpful? Yes No
aggneha9821 52 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji plz find screenshot

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

So, in the second screenshot, is it erroring out on Step 2?

That's very strange because your region should not have any reason to throw this off as we are dealing directly with a text variable.

I defer to others with non-US regional datetime conflicts. @Agnius, have you ever dealt with this?

Regards,

Mike

Was this reply helpful? Yes No
aggneha9821 52 on at

Like (0)

Report
Copy link

Link copied!

@MichaelAnnis yes In second action it's throwing error as the provided text value can't be converted into valid datetime

Was this reply helpful? Yes No