Format-Date Function

On a screen, I am trying to format the date/time in the {{date}} field to display seconds. I see the FORMAT-DATE function but I'm not sure where to place the function. In the dynamic value field of the {{date}} field? Or do I need to create a hidden field and run the function there?

  • You can find documentation on this here under Section 4: 

    1) Put a hidden field right under this date field

    2) In your new hidden fields dynamic value put the following formula FORMAT-DATE({{date}}, 'yyyy-MM-dd HH:mm:ss')

    Its important to remember for your output that you reference your hidden fields data name, otherwise if you reference the original date field data name you wont see the format-date changes you made.

    Below is more information regarding this formula.

    1 person likes this
Login or Signup to post a comment