Unanswered

Error- The datetime string must match ISO 8601 format

(0) Share

Report

Posted on by Liel

Hi,

I have an issue with formatDateTime function.
Since last Sunday, this action stopped working for me and I receive the error message:

Unable to process template language expressions in action 'Compose-_TEST' inputs at line '1' and column '2898': 'In function 'formatDateTime', the value provided for date time string '15/03/2021' was not valid. The datetime string must match ISO 8601 format.'.

When I run the expression below:

formatDateTime(outputs('Compose')[0],'yyyy-MM-dd')

Can you please assist?

This expression worked fine until last Sunday.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @Liel

Is it possible that your error begain on 13th? The reason I ask is that 13/03/2021 is not a valid date in a MM/dd/yyyy format as there are not 13 months in a year. Where does your date in compose come from - is it a string?

Damien

Was this reply helpful? Yes No
Liel 8 on at

Like (0)

Report

Hi Damien,

Thanks for your quick answer.
I receive the date as a string in format dd/mm/yyyy means that 15th is the current date in this case.
Can I use formatDateTime function in this scenario?
You're right, if I change it to '03/15/2021' instead '15/03/2021'- it is working.

Regard,
Liel

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (2)

Report

Hi @Liel

You can re-organise your date string as follows:
This runs as follows:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

Was this reply helpful? Yes No
Liel 8 on at

Like (1)

Report

Thank you, in this way it is working!

Was this reply helpful? Yes No
MWibisono 75 on at

Like (0)

Report

I tried formatting date to yyyy-MM-dd, but it has to be the day I code, for example I want to format date 15-12-2023, but I did it on 14-12-2023, I got an error.

Was this reply helpful? Yes No