How to set date time format in Logic App

Question

I have created an API which creates an excel having Date columns too. When I execute the code from local it works well and displays the date as expected.

When I try executing API via Logic App, it changes the date format of that field. How can I set date time in Logic App?

Answer 1

When you have a fixed DateTime-Format you can use the Logic App function "formatDateTime" as follow:

formatDateTime(triggerBody()?['myDate'], 'yyyy-MM-dd')

You can find it under Expressions - Date and Time - "See more" - formatDateTime

Answer 2

I found some useful documentation on Microsoft's site here:

https://learn.microsoft.com/en-us/azure/kusto/query/format-datetimefunction

Here it is .. in action: