Published at: 2026-09-17
Date
Overview
The date field records business time information that only requires day-level precision, such as creation dates, due dates, and contract signing dates. This field supports multiple display format variations. The underlying data is always stored as a standard date type and can participate in formula calculations and filter condition configuration.
Basic specifications
| Attribute | Description |
|---|---|
| Applicable scenario | Creation date, due date, etc. |
| Underlying storage | Always stored as a standard date type |
| Display format | Supports Year-Month-Day, Year-Month, Year-Quarter, and Year format variations |
Configuration highlights
- Display format: The format configured by the administrator only affects list page display, front-end filter conditions, and exported text format.
- Create page behavior: Regardless of the display format setting, users must still select a specific date when creating a record. The system saves the complete date and then displays it according to the configured format.
[!TIP] For example, if an administrator sets the date field display format to “Year-Month”, users still need to select a specific date when creating a record on the front end.
Default values and required settings
Default value
Date fields support default values through formula calculations:
- Use the
TODAY()function to return the current date. - Use
DATE(year, month, day)to construct a specific date. - Use date offset functions such as
TODAY() + DAYS(7)to set a date 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
- When date fields participate in formula calculations, date subtraction results are in days.
- Date fields and date/time fields cannot be directly subtracted. Use the
DATETIMETODATE()function to convert first.
FAQ
The date field format is set to “Year-Month”, but the create page still asks me to select a day — why?
The format setting for the “Date” type field currently affects: the date field display on the object list page, filter conditions when selecting the date, and object data export.
Therefore, regardless of the display format setting, users must still select a specific date when creating a record. The system saves the complete date and then displays it according to the configured format.