Unanswered

How to transform different date formats to yyyy-MM-dd

(0) Share

Report

Posted on by Jens_km

Dear friends,

I'm facing a case where the date format could be different from a document to another (I extract the date from pdf docs using AI Builder in the flow). I'd like to transform them into the format "yyyy-MM-dd", which can be recognized by the filter query of the SharePoint.

Different formats could be:

- 'dd.MM.yyyy'

- 'yy/MM/dd'

- 'dd-MM-yyyy'

When I tired to transform them to the yyyy-MM-dd using the "formatDateTime" expression, I usually face the error such as: "Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '14-03-2023' was not valid. The datetime string must match ISO 8601 format.'."

Could you suggest any solution for me? Thank you.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Chriddle 8,706 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

parseDateTime(datestring, locale?, format?) returns an ISO 8601 formatted date string.

Was this reply helpful? Yes No
Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jens_km ,
I hope it will be reading system time format, first check while reading from ai builder which format you are getting else if you change format in SharePoint as a text format it will works fine.

Regards
Ahammad Riyaz
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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

Like
a
(0)

Report
Copy link

Link copied!
This expression can parse your mentioned formats:
if( contains(item(), '/'), parseDateTime(item(), 'es-es', 'yy/MM/dd'), parseDateTime(item(), 'es-es') )

Was this reply helpful? Yes No