Unable to convert italian to english date format (dd/MM/yyyy -> yyyy-MM-dd)

(0) Share

Report

Posted on by JaRJaR55

Hello everyone,

I'm trying to convert thedate 21/02/2022 to 2022/02/21, with this code:

formatDateTime(outputs('ComponiData'), 'yyyy-MM-dd', 'en-US')

But, I receive an error:

In the 'formatDateTime' function the value specified for the date / time string '21/ 02/2022 'is not valid. The date / time string must conform to the ISO 8601 format. '."

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @JaRJaR55,

First of all it looks like that there is a space character just before the month. Is that a small typo?

It also looks like your data is of type string. You can rearrange it a bit to make it usable for a formatdatetime function.

As a workaround you could use a couple of substring functions to get it in a right format:

formatDateTime(concat(substring(outputs('ComponiData'),3,2),'/',substring(outputs('ComponiData'),0,2),'/',substring(outputs('ComponiData'),6)),'yyyy-MM-dd')

Was this reply helpful? Yes No