How to add time with Liquid templates in Azure Logic Apps?

Question

I'm trying to add a specific duration to a particular datetime field in my JSON to JSON Transform input Content, using methods as demonstrated in this answer. However, logic apps use dotliquid internally, the default config of which uses .NET date format strings instead of Ruby's.

I could find no available .NET date format alternative for Ruby's %s (returns the number of seconds since the Unix epoch) which is essential to the operation.

Answer 1

You can use "formatDateTime" method in logic app to customize the format of your date and then put it in Liquid.

Answer 2

Example to add 6 hours and 30 minutes from now and format :

{
  "outputKey" : {{ "now" | Date: "yyyy-MM-ddThh:mm:ss" | Append: "-06:30" | Date: "yyyy-MM-ddThh:mm:ss"}}
}