Date and Time values in Form entries

Date and Time values in Form entries

Dates and times are captured as follows on form entries:

  • Date only and Time only fields are captured in the local device time, but without any timezone information. As such, these are always displayed as the raw, local time values, without any time zone adjustment.
  • Date/Time fields are captured with timezone information since they have a complete date and time dataset.

These values are output on the web platform with adjusted time zone based on the logged-in user's timezone, or if not set (or if running in a Connector context) then the Organization Setup timezone settings.

Our API mirrors the above, in that date-only and time-only fields return just raw DD-MM-YYYY or HH:MI:SS values, while Date/Time fields return as ISO 8601 format (i.e., time zone inclusive). All other date/time values found on our API accept and return ISO 8601 format.


    • Related Articles

    • Date/Time Field Type

      TABLE OF CONTENTS Basic Properties Data Name Title Text Hint Text Date/Time Type Working with Date & Time values in formula and bound Data Source scenarios How to get Date & Time values stored in your local time zone Layout & Styling Field Layout ...

    • NetSuite - Form Connector

      Our Premium connector for NetSuite allows you to easily push data and files captured from your forms directly into your NetSuite account. This creates a seamless, one-way synchronization, ensuring all your data is automatically updated in your ...

    • Google BigQuery Form Connector

      This is a Premium connector for direct connection to Google's BigQuery database service. Our platform enables you to quickly and easily insert your Form Entries as rows in a target BigQuery database table. This enables a one-way synchronization to ...

    • QuickBooks - Form Connector

      Our platform lets you easily add and quickly configure a one-way synchronization of form-captured data to QuickBooks. After adding and authenticating a QuickBooks Connection, QuickBooks Form Connectors can be added to Data Entry Forms to push data ...

    • Calculating the Duration/Time elapsed between two form fields

      For some questionaire/survey-type scenarios, you may wish to track the time it takes the user to fill out a Form, or maybe a section in the Form. This is done by storing a corresponding start and end date/time value, with these values being set when ...