How to Convert date format "2023-06-22T15:11:46Z" to "dd-MM-yyyy" ?

Like (0) Share

Report

Posted on 22 Jun 2023 15:20:19 by CU16021406-1

1,037

Dear experts,

I need to convert this format date: 2023-06-22T15:11:46Z

to only: dd-MM-yyyy

I have tried it but no luck:

i get the error:

InvalidTemplate. Unable to process template language expressions for action 'Convert_time_zone' at line '0' and column '0': 'In function 'converttimezone', the value provided for date time string '["2023-06-22T15:11:46Z"]' was not valid. The datetime string must match ISO 8601 format.'.

I have the same question (0)

All responses (5)

Answers (1)

annetoal 1,934 Moderator on 22 Jun 2023 at 21:56:43

Like (0)

Report

Re: How to Convert date format "2023-06-22T15:11:46Z" to "dd-MM-yyyy" ?

.

Was this reply helpful? Yes No
CU16021406-1 1,037 on 22 Jun 2023 at 17:03:13

Like (0)

Report

Re: How to Convert date format "2023-06-22T15:11:46Z" to "dd-MM-yyyy" ?

Yes, you are right. Thank you. It works now. Gr. P

Was this reply helpful? Yes No
Verified answer

annetoal 1,934 Moderator on 22 Jun 2023 at 16:10:35

Like (0)

Report
Re: How to Convert date format "2023-06-22T15:11:46Z" to "dd-MM-yyyy" ?

Shouldn't your dynamic output 'ResponseDate" expression look like

outputs('ResponseDate')

Can you select it from your dynamic outputs?

Was this reply helpful? Yes No
CU16021406-1 1,037 on 22 Jun 2023 at 16:00:18

Like (0)

Report

Re: How to Convert date format "2023-06-22T15:11:46Z" to "dd-MM-yyyy" ?

Still received the same error message.

formatDateTime('ResponseDate', 'dd-MM-yyyy')

Was this reply helpful? Yes No
annetoal 1,934 Moderator on 22 Jun 2023 at 15:35:48

Like (0)

Report
Re: How to Convert date format "2023-06-22T15:11:46Z" to "dd-MM-yyyy" ?

Use this expression:
formatDateTime('2023-06-22T15:11:46Z', 'dd-MM-yyyy')

If this helped, please mark it as a Solution.

Anne

Was this reply helpful? Yes No