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,195 Most Valuable Professional on at

Like (0)

Report
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

Yes it is from same task 🙂

but still i get yyyy-dd-MM

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
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

Hello,

that worked. amazing

Thank you

Was this reply helpful? Yes No

Join the conversation