Answered

Converting a date string (format ddmmyyyy) to datetime

(0) Share

Report

Posted on by collinnunis

Hi there, I am trying to convert a string that has format ddmmyyyy to a standard DateTime format. I've tried using both formatDateTime and parseDateTime formulas in Power Automate but I keep getting this error:

'In function 'parseDateTime', the value provided for date time string '23022024' was not valid. The datetime string must match ISO 8601 format.'.

Has anyone had a similar issue before?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @collinnunis ,

I did a test for your reference.

In my scenario:

substring('23022024',0,2) substring('23022024',2,4) substring('23022024',4,4) parseDateTime(concat(outputs('Compose_Year'),'-',outputs('Compose_Month'),'-',outputs('Compose_Day')))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Verified answer

collinnunis 25 on at

Like (1)

Report
Hi @v-yetonggu-msft, thank you for your response. I thought about using substring or slice, but I was able to do it this way:

The formulas I used:

formatDateTime(concat(substring(item()?['End Date'], 4, 4), '-', substring(item()?['End Date'], 2, 2), '-', substring(item()?['End Date'], 0, 2), 'T00:00:00Z'), 'en-AU', 'dd/MM/yyyy') formatDateTime(concat(substring(item()?['Transaction Date'], 4, 4), '-', substring(item()?['Transaction Date'], 2, 2), '-', substring(item()?['Transaction Date'], 0, 2), 'T00:00:00Z'), 'en-AU', 'dd/MM/yyyy')

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report
Why all these substrings?

Use parseDateTime() with an appropriate format string:

parseDateTime('23022024', 'es-es', 'ddMMyyyy')

1 people found this reply helpful.

Was this reply helpful? Yes No
collinnunis 25 on at

Like (0)

Report

Thank you so much @Chriddle !

Was this reply helpful? Yes No