Answered

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: https://support.formsonfire.com/support/solutions/articles/36000042514-formula-cheat-sheet 


    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