Published at: 2026-09-17
Date/time
Overview
The date/time field records both date and time information. It is suitable for scenarios that require minute-level precision, such as creation time, approval deadline, and shipment time. This field supports multi-time-zone configuration, ensuring that users in different regions see the correct local time in multinational enterprises.
Basic specifications
| Attribute | Description |
|---|---|
| Applicable scenario | Creation time, update time, deadline, etc. |
| Format | 2026-07-02 14:30 |
| Content | Date + Time |
Configuration highlights
- Default value: Set the default value through a formula.
- Time zone: Tenants in the multi-time-zone gradual rollout use the tenant time zone. Others use UTC+8.
Default values and required settings
Default value
Date/time fields support default values through formula calculations:
- Use the
NOW()function to return the current date and time. - Use
DATE(year, month, day)to construct a specific date. - Use date/time offset functions such as
NOW() + DAYS(7)to set the date/time 7 days from now.
[!NOTE] The default value is auto-filled when creating a new record in the front end. Users can modify it after pre-filling. After modifying a default value formula, historical data is not recalculated.
Required configuration
- Field-level required: On the field configuration page, set “Required” to “Yes”. This applies across all scenarios (front-end entry and back-end import). Missing values prevent saving.
- Layout-level required: If the field is required only in specific business scenarios, set it as not required in the field properties. Then, in the specific page layout editor, check “Required”.
- Conditional required: If the required condition depends on the value of another field, configure validation rules.
Usage limitations
- Date/time fields and date fields cannot be directly subtracted. Use the
DATETIMETODATE()function to convert first. - Date/time subtraction results are in hours.