Fields/Field types/Date Time based

Date

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

Date field type is used to store date values. NocoDB supports a wide range of date formats, as detailed in the table below.

Create a date field

Click on + icon to the right of Fields header
On the dropdown modal, enter the field name (Optional).
Select the field type as Date from the dropdown.
Configure Date Format
Configure default value (Optional)
Click on Save Field button.

Supported date formats

Format	Example
YYYY-MM-DD	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
MM/DD/YYYY	09/22/2023
DD MM YYYY	22 09 2023
MM DD YYYY	09 22 2023
YYYY MM DD	2023 09 22

Date Time

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

Time

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