Date Time
A date and optional time, including created/updated stamps.
Type
date-timeValue
Editable
Unique
Yes
Date Time stores a point in time. New tables include a Created At column of this type. Use Relative Time to show elapsed time, and Duration for a span between two dates.
Name, key, unique, hidden, and permissions are the same for every column — see Tables.
Configure
| Setting | Description |
|---|---|
| Date / Time | Include a date, a time, or both |
| Relative | Show as relative time in the grid |
| Format | Optional display format |
| Timezone aware | Store and show with timezone |
| Min Date / Max Date | Allowed range |
| Auto Fill | None, Created At, or Updated At. Locked after create. When set, the cell is filled for you. |
Use case
- Due dates, appointment slots, or event start times you sort and filter in the grid.
- Created At / Updated At auto-fill for audit-style stamps you never type.
- Point Relative Time and Duration at this column for “how long ago” and “how long it took.”
- Date-only for deadlines; date + time (and timezone) for meetings and SLAs.