Convert string to date format

(0) Share

Report

Posted on by guju

Hi!

I am reading from a CSV file some dates. These dates are in the format dd-MM-YYYY. If i want to convert the string to a date i always fail.

For this i use

juergen contains

18/05/2020

formatDateTime(variables('Juergen'), 'dd-MM-yyyy')

The system fails, because it expects it in the format MM-dd-yyyy. Can i change the expected format for the conversion? The only way i can think of is to manually change the string....Do you have any idea how to do it without changing the string?

Kind regards,

Juergen

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @guju ,

Please try the following expression:

formatDateTime(concat(split(variables('Test'),'/')[1],'/',split(variables('Test'),'/')[0],'/',split(variables('Test'),'/')[2]),'dd-MM-yyyy')

Best Regards,

Was this reply helpful? Yes No