Skip to content

Date

Reference5 minFoundation

Capture a calendar deadline, such as a contract ending on 31 December 2026. Date has no time; use Date time for a delivery appointment that starts at 09:30.

A calendar date without a time.

DATE

Use when

  • Contract end date: 31 December 2026

Choose another type for

  • Meeting start times

On a form

A date picker displaying dd/MM/yyyy.

In views

Can be selected for configured data view columns. Spreadsheet editing is offered for own, non-key fields of this type when the column is editable.

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

Contract end date: 31 December 2026

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 field configuration and its type-specific settings.

    Name the field

    Section titled “Name the field”

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

    What's next

    Which field type should I use?Choose a field type by what people will enter and what you want to do with it later, from short text and dates to lookups, relations and smart fields.Add a fieldAdd a field to a module so people can capture a new piece of information, such as a contract's end date.

    Last checked