Logic Apps - liquid template - date conversion

Question

I'm using liquid templates in logic apps / integration account to transform a JSON message, but I'm struggling with a date conversion.

The inputdate is datetime "2020-07-22T12:00:00" and I need to convert it to 2020-07-22"

But I don't find the right syntax for that.

Currently I have the following conversion in my liquid templates.

"executionDate": "{{ content.ExecutionDate | date: "%d/%m/%Y" }}",

But this returns "8/6/2020 12:00:00 PM"

How can this be done?

Answer 1

Hi,

I was having exactly the same issue. It turns out the syntax isn't the same as on the Liquid docs. You need to use:
"executionDate": "{{ content.ExecutionDate | Date: "dd/MM/yyyy" }}", notice the capitalisation of "Date"

See following article for details:
https://social.technet.microsoft.com/wiki/contents/articles/51275.microsoft-azure-liquid-templates-in-logic-apps.aspx

I hope that helps!