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
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 ...
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 ...
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 ...
Form Connector – PostgreSQL
After adding and authenticating a PostgreSQL Connection, you can add Data Source Connectors to pull data from a database or push data on form submissions using Form Connectors, which this article is about. Our platform lets you quickly and easily ...
Form Connector – SQL Server
After adding and authenticating an SQL Server 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 ...