# Date, Time and Date & Time fields

> Store a date, a time of day, or both. Set default values, fill a field automatically when a record is created or changed, and choose date and time formats.

Source: https://tadabase.com/docs/data/date-fields  
Status: Verified Nov 17, 2026. Checked against the current product

Date fields store a calendar date, a time of day, or both. Use them for due dates, appointment times, or a record's own created and modified timestamps.

## Which type to use

| Type in the field menu | What it stores | Example |
| --- | --- | --- |
| **Date** | A day, month and year | Due date, birthday |
| **Time** | An hour and minute | Opening time, shift start |
| **Date & Time** | A date and a time together. The field settings call this type **Date/Time**. | Appointment, last contact |

For a start and an end in one field, use [Date Range](https://tadabase.com/docs/data/date-range). To calculate a date from other fields, use a [Date Formula](https://tadabase.com/docs/data/date-formula).

## Add a date field

1. **Open the table** In the **Data Builder**, open the table and go to its **Fields** tab.
2. **Pick the type** Click **Add New Field**, then under **Date** click **Date**, **Time** or **Date & Time**.
3. **Configure it** Click **Add and Configure**, enter a **Name**, set the options below, and click **Save**.

## Field settings

Date, Time and Date & Time fields have the same three settings. The menu items use the field's own word: **Current Date**, **Current Time** or **Current Date/Time**, and **Specific Date**, **Specific Time** or **Specific Date/Time**.

| Setting | Choices | What it does |
| --- | --- | --- |
| **Default Record Value** | None, the current date or time, or a specific one | Saved when a new record is created with this field left blank. Existing records are not changed. |
| **Default Form Value** | None, the current date or time, or a specific one | Already filled in when a form with this field loads in the live app. The person can change it before submitting. |
| **Auto-populate with** | None, **Record Created**, **Record Modified** | Fills the field with the record's own timestamp. **Record Created** is set once, when the record is added. **Record Modified** is set on creation and refreshed every time the record is saved. Either one overrides any value entered on a form. |

![The settings of a Date field, with Default Record Value, Default Form Value and Auto-populate with](https://tadabase.com/docs-shots/data-date-field-settings.webp)

> **Track when records change:** Add a Date & Time field named "Last Updated" and set **Auto-populate with** to **Record Modified Date/Time**. Every save then stamps the record, with no workflow needed. Every table also has a built-in **Created On** field.

## Date and time formats

The format is set for the whole app, not per field. Go to **Settings** > **General Settings**, **Basic Settings** tab:

- **Date Format**: `MM/dd/yyyy`, `MMM dd, yyyy`, `dd/MM/yyyy` or `dd.MM.yyyy`.
- **Time Format**: `hh:mm a` (12-hour, with AM or PM) or `HH:mm` (24-hour).

A table or details component can show one column differently. In the column's settings, **Date Format** and **Time Format** offer more formats, such as `yyyy-MM-dd` or `HH:mm:ss`, and **Hide** to show only the date or only the time of a Date & Time field.

The same column settings have an **Output Format** for Date and Date & Time fields: **Date** shows the value, **Stop Watch** shows the time counted from the value as a stop watch, and **Age** shows the time since the date in years, with **Include Month** and **Include Days** to add detail.

## Time zone

Tadabase uses the app's **Timezone** setting in **Settings** > **General Settings** for date and time values, including current-date defaults and **Auto-populate with** timestamps. Every user sees the same stored date and time. Set the time zone before you collect data, so timestamps match where your team works.
