datetime string must match ISO 8601 format

(0) Share

Report

Posted on by ST-11030830-0

Hello I keep receiving an error message when running a test flow that says: "Unable to process template language expressions in action 'Birthday_MMDD' inputs at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string '13-03-1979' was not valid. The datetime string must match ISO 8601 format.".

I've changed the date format but it keeps coming back. I don't know what to do anymore.

Did someone experience the same problem and could help?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Patel Asutosh 27 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please share a screenshot of the action so we can better understand the issue?

Also, if you are using Excel, please ensure that the DateTime format has been changed to ISO format.

Was this reply helpful? Yes No
Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

The ISO date standard is used throughout the Power Platform. Actions involving dates expect the date to be in this format, which is yyyy-MM-ddThh:mm:ssZ. You can learn more about this standard at https://learn.microsoft.com/en-us/power-automate/date-time-values#format-date-and-time. This page provides information for getting your date into the ISO format.

And as @Patel Asutosh 27 mentioned, if the date is in Excel be sure to check the ISO date format option or you'll need to convert the Excel serial date to ISO first: addDays('1899-12-30',int(triggerBody()['number_1']),'yyyy-MM-dd')

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!
parseDateTime('13-03-1979', 'es-es', 'dd-MM-yyyy')

returns '1979-03-13T00:00:00.0000000'

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
To get '0379' use the following:

formatDateTime parseDateTime('13-03-1979', 'es-es', 'dd-MM-yyyy'), 'MMyy' )

Was this reply helpful? Yes No