Date-Time
The date-time field is used to represent a combined date and time value in documents. It stores the input as an ISO 8601 string in UTC and displays it in the user's local timezone.
Use a date-time field when you need to capture a precise moment in time (e.g. a work order start, an approval timestamp) and want to perform duration calculations between two such values. For cases where date and time are logically independent, use separate date and time fields instead.
Properties
| Property | Required | Purpose |
|---|---|---|
| Minimum Value | No | Defines the earliest date and time value allowed. |
| Dynamic Minimum | No | Sets the minimum value based on a condition or another field's value. |
| Maximum Value | No | Defines the latest date and time value allowed. |
| Dynamic Maximum | No | Sets the maximum value based on a condition or another field's value. |
| Interval | No | Specifies the number of minutes by which the time portion increments or decrements when using the picker. |
| Enforce Interval | No | Only allows inputs that match the defined interval. For example, if the interval is 5, only times rounded to 5-minute intervals will be saved. |
Using Date-Time Values in Expressions
Date-time values are ISO 8601 strings and can be used directly in BizzStream expressions.
Calculate the duration in hours between two date-time fields:
(FORMAT(F["endDateTime"], "X") - FORMAT(F["startDateTime"], "X")) / 3600