web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Convert time from dd/M...

Power Automate

Answered

Convert time from dd/MM/yy to yyyy-MM-dd

(0) Share

Report

Report

Posted on by PMM

14

Hello,

i stuck on this.

i have date 01/07/2021 dd/MM/yyyy i need convert it to 2021-07-01.

whatever commands or time converter i am using i get 2021-01-07

convertTimeZone(outputs('Compose_4'),'UTC','Romance Standard Time','yyyy-MM-dd')

formatDateTime(outputs('Compose_4'),'yyyy-MM-dd')

any tips how convert it?

thank you

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @PMM,

Just to double check. Is this still the date you are extracting from the subject of an e-mail.

Discussed in this thread:

https://powerusers.microsoft.com/t5/Building-Flows/Extract-date-from-outlook-subject-or-body/m-p/949100

If so, try and use this directly after your split action:

formatdateTime(split(outputs('Html_to_text_2')?['body'], '_')[3], 'yyyy-MM-dd')

Was this reply helpful? Yes No
PMM 14 on at

Like (0)

Report
Copy link

Link copied!

Yes it is from same task 🙂

but still i get yyyy-dd-MM

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @PMM,

Sorry, I misread your current format. It is actually the 1st of July and not the 07th of January, my bad 😁

Try this instead:

formatdatetime(formatdateTime(split(outputs('Html_to_text_2')?['body'], '_')[3], 'dd/MM/yyyy'), 'yyyy-MM-dd')

Was this reply helpful? Yes No
PMM 14 on at

Like (0)

Report
Copy link

Link copied!

Hello,

that worked. amazing

Thank you

Was this reply helpful? Yes No

Join the conversation