> ## Documentation Index
> Fetch the complete documentation index at: https://help.teable.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Date

> Store dates and times, with support for date format, time format, time zone, and auto-fill current time.

A **Date** field stores a specific date or point in time, such as a project deadline, meeting time, or employee start date. It can show only the date, or include a time such as `2025-11-03 14:30`.

## Use Cases

| Scenario                    | Good for                                          |
| --------------------------- | ------------------------------------------------- |
| Project scheduling          | Task start dates, deadlines, milestone dates      |
| Event planning              | Meetings, events, appointments, release plans     |
| People and contract records | Start dates, signing dates, expiration dates      |
| Period reporting            | Filter and report data by week, month, or quarter |

## Create and Configure

<Steps>
  <Step title="Choose the field type">
    In table view, add a field and choose **Date**.
  </Step>

  <Step title="Name the field">
    Enter a field name, such as "Due Date", "Meeting Time", or "Start Date".
  </Step>

  <Step title="Configure date options">
    Set the date format, whether to include time, the time format, and the time zone as needed.
  </Step>

  <Step title="Set the default value">
    If new records should use the current time automatically, enable auto-fill current time.
  </Step>
</Steps>

## Date Field Options

| Option                 | Description                                                                              |
| ---------------------- | ---------------------------------------------------------------------------------------- |
| Include time           | Store a specific time in addition to the date                                            |
| Date format            | Controls date display, such as `YYYY-MM-DD`, `DD/MM/YYYY`, `MM/DD/YYYY`, or `D MMM YYYY` |
| Time format            | Controls whether time is shown, and whether it uses 12-hour or 24-hour time              |
| Time zone              | Sets the time zone used for dates and times, useful for teams across regions             |
| Auto-fill current time | Fills new records with the current time when they are created                            |

For more formats, see [Formatter](/en/basic/field/common/formatter).

## Common Uses

* **Task scheduling**: Record start dates and due dates, then sort or filter by due date.
* **Event planning**: Record meeting and event times so important dates are easy to track.
* **Period reporting**: Filter data for this week, this month, or a custom date range.
* **Date calculations**: Reference Date fields in Formula fields to calculate intervals between dates.

## Notes

<Tip>
  If you need to record when a record was created and keep that value read-only, use **[Created Time](/en/basic/field/created-time)**.
</Tip>