Product Docs
NocoDocs
Workflows
Scripts
Self Hosting
Changelog

Date Time

This article explains how to create & work with a Date Time field.

Date Time field type is used to store both date and time values in a single field.

Create a date time field

  1. Click on + icon to the right of Fields header
  2. On the dropdown modal, enter the field name (Optional).
  3. Select the field type as DateTime from the dropdown.
  4. Configure Date Format
  5. Configure Time Format
  6. Configure default value (Optional)
  7. Click on Save Field button.

image

Supported date formats

FormatExample
YYYY-MM-DD2023-09-22
dddd YYYY-MM-DDFriday 2023-09-22
ddd YYYY-MM-DDFri 2023-09-22
YYYY/MM/DD2023/09/22
DD-MM-YYYY22-09-2023
MM-DD-YYYY09-22-2023
DD/MM/YYYY22/09/2023
dddd DD/MM/YYYYFriday 22/09/2023
ddd DD/MM/YYYYFri 22/09/2023
MM/DD/YYYY09/22/2023
dddd MM/DD/YYYYFriday 09/22/2023
ddd MM/DD/YYYYFri 09/22/2023
DD MM YYYY22 09 2023
MM DD YYYY09 22 2023
YYYY MM DD2023 09 22
DD MMM YYYY22 JAN 2024
DD MMM YY22 JAN 24
DD.MM.YYYY15.09.2024
DD.MM.YY15.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 offers Jalali (Persian / Solar Hijri) formats such as jYYYY/jMM/jDD, jYYYY-jMM-jDD, jDD/jMM/jYYYY, jDD-jMM-jYYYY, jDD jMMMM jYYYY, and jDD jMMM jYYYY. Selecting one displays and accepts the date part in the Jalali calendar, and the date picker switches to the Persian calendar for that field.

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

FormatExample
HH:mm:ss12:45:30
HH:mm14:20
Tags:FieldsField typesDate & Time

Date

This article explains how to create & work with a Date field.

Time

This article explains how to create & work with a Time field.