Skip to content

Date time

Reference5 minFoundation

Capture a delivery appointment with both its day and time. The form displays the date and time together and passes the workspace time zone to its date converter.

A calendar date with a time.

DATE_TIME

Use when

  • Delivery appointment: 14 October 2026 at 09:30

Choose another type for

  • Date-only deadlines

On a form

A date and time picker displaying dd/MM/yyyy HH:mm:ss.

In views

Can be selected for configured data view columns. Configure its display in the data view settings.

In Smart Script

getCurrentValue() has a String return type for every field type; an unset value can be null. Parse the date text before date arithmetic.

Import and export

The importer cleans the cell text and forwards it as a string. Inspect the analysis preview before confirming. Configure field settings, defaults and form rules in the destination workspace.

Example

Delivery appointment: 14 October 2026 at 09:30

Settings

SettingWhat it does
Show in record detailsIncludes this field in the record details; forms and data views are configured separately.
Show in the record headerIncludes this field among the record header fields.
PositionSets the order in record details; lower numbers appear first.
Virtual fieldComputes the value at display time instead of storing it.
Encrypt valuesChoose encryption when you create the field.
Encryption keySelect an ACTIVE encryption key.
Default valueSets a plain value or Smart Script for new records.
The Date time field configuration and its type-specific settings.

    Start the field name with an English letter. Use letters, digits, spaces and underscores.