Date Time

Use the Date Time field type to store a date and a time in one field.

Create a date time field

Click the + icon to the right of Fields header.
In the dropdown modal, enter the field name (Optional).
In the dropdown, select the field type DateTime.
Configure Date Format.
Configure Time Format.
Configure the default value (Optional).
Click Save Field.

Supported date formats

Format	Example
YYYY-MM-DD	2023-09-22
dddd YYYY-MM-DD	Friday 2023-09-22
ddd YYYY-MM-DD	Fri 2023-09-22
YYYY/MM/DD	2023/09/22
DD-MM-YYYY	22-09-2023
MM-DD-YYYY	09-22-2023
DD/MM/YYYY	22/09/2023
dddd DD/MM/YYYY	Friday 22/09/2023
ddd DD/MM/YYYY	Fri 22/09/2023
MM/DD/YYYY	09/22/2023
dddd MM/DD/YYYY	Friday 09/22/2023
ddd MM/DD/YYYY	Fri 09/22/2023
DD MM YYYY	22 09 2023
MM DD YYYY	09 22 2023
YYYY MM DD	2023 09 22
DD MMM YYYY	22 JAN 2024
DD MMM YY	22 JAN 24
DD.MM.YYYY	15.09.2024
DD.MM.YY	15.09.24

The dddd (full weekday, e.g. Friday) and ddd (short weekday, e.g. Fri) variants prefix the day of the week to the date. The weekday prefix is display-only: it appears in cells and in grid group-by headers, while records still sort and group on the underlying date. The weekday name currently renders in English only.

The Date Format dropdown also has Jalali (Persian / Solar Hijri) formats: jYYYY/jMM/jDD, jYYYY-jMM-jDD, jDD/jMM/jYYYY, jDD-jMM-jYYYY, jDD jMMMM jYYYY and jDD jMMM jYYYY. When you select one, the field shows and accepts the date part in the Jalali calendar. The date picker for that field also changes to the Persian calendar.

The Jalali calendar affects display and data entry only. Values are still stored as standard (Gregorian) dates, so sorting, filtering, formulas, and API responses are unchanged. This is chosen per field through the date format and is independent of the application language.

Supported time formats

Format	Example
HH:mm:ss	12:45:30
HH:mm	14:20

Date Time

Create a date time field

Supported date formats

Supported time formats

Related