# Baserow Date Field - Formats, Calendar, and Auto Timestamps

> Baserow ships a manual date field plus two automatic timestamps - see format options, the calendar picker, timezone behavior, and when to use each one.

Source: https://opennix.org/en/docs/baserow/field-types/date-and-time-fields/


Baserow handles dates through three related field types: a regular date field with manual entry and a calendar picker, plus two automatic timestamps that track when a row was created and when it was last edited. This article covers how to add a date field, which date and time formats are available, how the automatic fields differ from manual entry, and how timezone settings affect the value you see.

## Overview

The three field types cover different scenarios for working with dates and times:

1. **Date field (manual):** An editable field where a person types a date and time directly or picks one from a calendar. Suited to deadlines, birthdays, or project start dates.
2. **Created on (automatic):** A non-editable field that captures the moment a row was added to the table.
3. **Last modified (automatic):** A non-editable field that records the moment a row was last edited.

## Date field (manual)

### Adding a date field

To add a date field:

1. Click the plus sign (+) in your table.
2. Select **Date** from the field type list.
3. Name the field (for example, "Deadline" or "Start date").
4. Click **Create**.

![Adding a new date field in Baserow](/images/baserow/field-types/date-and-time-fields-adding-date-field.jpg)

### Filling in the date field

There are two ways to set a value:

- **Manual entry:** type the date directly into the cell.
- **Calendar picker:** click the cell to open an interactive calendar for picking a date and time.

### Format options

#### Date formats

| Format | Example |
|---|---|
| European | `DD/MM/YYYY` (20/02/2020) |
| US | `MM/DD/YYYY` (02/20/2020) |
| ISO | `YYYY-MM-DD` (2020-02-20) |

#### Time formats

The "Include time" toggle adds a time component to the field:

- **24-hour:** for example, 23:00.
- **12-hour:** for example, 11:00 PM.

The date and time format is set once for the whole field and applies to every row the same way - change it later from the field's [configuration menu](/docs/baserow/fields/field-customization/).

## Created on field

This automatic field shows the exact date and time a row was created. It cannot be edited manually, which makes it useful for auditing, tracking new entries, or sorting by creation date. Formatting works the same way as on the manual date field.

![A Baserow table showing the Created on field](/images/baserow/field-types/date-and-time-fields-created-on-field.jpg)

## Last modified field

The last modified field works on the same principle as created on, but it updates automatically every time a row is edited rather than only once when the row is added. For the full breakdown of its settings and behavior, see the dedicated [Last Modified Field](/docs/baserow/field-types/last-modified-field/) article.

## Timezone behavior

By default, the date field and the created on field display time based on your computer's local timezone. If a workspace has members across several regions, it is worth setting a consistent timezone at the field level - see [Working with Timezones](/docs/baserow/fields/working-with-timezones/) for the details.

## Filtering on date fields

Date fields support filter operators such as "is before," "is after," "is within," and "is today," which makes it straightforward to build views around deadlines or recent changes. The full operator list and examples of combining conditions live in the [Advanced Filtering](/docs/baserow/views/advanced-filtering/) article.

## What's next

To connect a date field with the rest of your table settings, read [Field Configuration](/docs/baserow/fields/field-customization/), or jump to [Advanced Filtering](/docs/baserow/views/advanced-filtering/) to build views around date criteria.