(Please note that older articles might not render correctly in mobile view.)
- Compatible Question Types
- Data Type Properties
- Exporting Date/Time Data: Format
The Date, Time, and Date/Time data types record data in an appropriate format for use in questions regarding dates and times. They are often used in Date/Time Stamp questions to record when work began or ended, or to mark the date on a form.
This data type can be collected with multiple Question Types:
|Date/Time Selector||Date/Time Stamp||Time-Based Math|
|Date||✓||✘ *||✘ **|
|Time||✓||✘ *||✘ **|
* The Date/Time Stamp only collects a Date/Time value and cannot be narrowed to a Date or a Time-only stamp.
** Time-Based Math requires a Date/Time value in order to calculate.
Data Type Properties
This is available on: Date/Time Selector, Time-Based Math.
Ensure that your users are entering appropriate dates by using Range Validation based on the question. For example, an Estimate form may have a future expiration date for the estimate's costs; using Range Validation set to "In the Future", you can ensure that your mobile users enter a future date.
This is available on: Date/Time Selector, Time-Based Math
Setting a default value can save time for your users by automatically entering a value based on a static time set by you; based on when they opened the page containing the date/time question; or the time they opened the form (data record start).
When Time/Date data is exported into CSV, it uses the ISO 8601 standard for Date/Time. For more information on the ISO-8601 standard, please read ISO 8601 (external link).
For information on how timezones may affect your output, please read: Timezone Settings