How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

(0) Share

Report

Posted on by Community Power Pla...

Dear Experts

I have been practising with datetime conversion from string to datetime format and I am really struggling

Below the flow

Formatdatetime(variables('DateTime'),'dd/mm/yyyy HH:MM')

but when I run it , I get the following error

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

Any help please?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous As clear from error message your date is not in ISO 8601 format. you may need to break it apart and rearrange it to the correct formatting to use it as a DateTime string. Make you date in this format- 2021-02-14T11:59:00
2021-02-14T11:59:00Z
20210214T115900Z

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

That is the error I am getting .. my question is how do I do that ?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous You need to use split expression here.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (2)

Report
@Anonymous

Expressions used
split(variables('Datetime'),' ') split(outputs('Compose_2')[0],'/') formatDateTime(concat(outputs('Compose_4')[2],'-',outputs('Compose_4')[1],'-',outputs('Compose_4')[0],' ',outputs('Compose_2')[1],':00'),'yyyy-MM-dd HH:mm')

--------------------------------------------------------------------------------
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
Community Power Pla... on at

Like (1)

Report

Thank you Sir, you are a star

Was this reply helpful? Yes No
diegocruzb96 22 on at

Like (0)

Report

Thanks man !!

Was this reply helpful? Yes No