Form Captured Date & Time Values

Form Captured Date & Time Values

Forms can capture Date, Time, or combined Date/Time data for each record.

Date only or Time only fields

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

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 Organisation 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 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 ...

    • Form Captured Data FAQ

      I have published a new Form version, but I am still seeing some Data entries coming in against the old Form version. Shouldn’t the users app have updated to the latest version automatically? The system will automatically update mobile users with the ...

    • FAQ- Data Captured

      Q: I have published a new Form version but I am still seeing some Data entries coming in against the old Form version. Shouldn't the users app have updated to the latest version automatically? A: The system will automatically update mobile users with ...

    • 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 ...

    • Form Connector – MySQL

      After adding and authenticating a MySQL Connection, you can add Data Source Connectors to pull data from a database or push data on form submissions using Form Connectors, which is what this article is about. Our platform lets you quickly and easily ...