Skip to main content

Date field

Store a date, an optional time, and an optional end date. Choose a date format, show dates in your calendar, and set a default.

Written by Leo

A Date field holds a date and, if you want, a time and an end date. With an end date, one field can describe a period, such as a viewing slot or a project phase. Date fields are meant to help you plan deadlines and appointments.

The record Sprint 12 with the date field Dates showing a start date and an end date, November 2 to 15, 2026

Note:

  • One field type covers dates and ranges. You turn the time and the end date on or off in the field settings.

  • Show in calendar is per field. Only date fields with Show in calendar turned on appear in your calendar.

Who can use the date field?

  • The date field is available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.

  • To add or change a field, you need Full access to the database app and a desktop or tablet.

Add a date field

  1. Open the database app, open the app menu, and select Customize record layout.

  2. Click + or type / in a text block.

  3. Under New field, select Date.

  4. Click the drag handle (⋮⋮) of the new field and select Edit field.

Opening Customize record layout from the app menu, clicking + next to a field, and clicking Date under New field so the new field appears in the layout

Clicking the drag handle of the date field Due date in the layout editor and selecting Edit field

Date field settings

In Edit field, you find:

  • Time: Hidden, Shown, or Required. With Required, a date needs a time.

  • End date: Hidden, Shown, or Required. With Required, start and end date are both needed.

  • Date format: how the date is written. Choose Full date, Long date, Short date, Numeric, or Relative.

  • Show in calendar: shows the dates of this field in your personal calendar. Learn more about your personal calendar →

  • Due date for status: uses the field as the due date of the status. This setting appears only when the database app has a status field. Learn more about the status field →

  • Default: the date a new record starts with.

The Edit field menu of the date field Due date with Time, End date, Date format, Show in calendar, Due date for status, Required, and Default

Default dates

Under Default, choose:

  • None: the field starts empty.

  • Now: the moment the record is created. This option appears only when Time is shown.

  • Today: the day the record is created.

  • Specific date: a fixed day that you pick.

Point at Now or Today to add an offset with Plus days, Plus weeks, or Plus months, for example a follow-up date seven days after the record is created.

The Default setting of a date field open with None, Now, Today, and Specific date

Change how dates look in a layout

In Edit field display, you can override the format for one layout:

  • Date format: Auto uses the field setting. You can also pick Full date, Long date, Short date, Numeric, Relative, MM/DD/YYYY, DD/MM/YYYY, or DD.MM.YYYY.

  • Time format: Auto, 12 hours, or 24 hours.

The Edit field display menu of a date field with Date format open, showing Auto, Full date, Long date, Short date, Numeric, Relative, MM/DD/YYYY, DD/MM/YYYY, and DD.MM.YYYY

FAQs

Can I add a time to a date later?

Yes. Set Time to Shown or Required under Edit field.

Can I turn a date into a date range?

Yes. Set End date to Shown or Required. A date field with an end date shows the start and the end. Very old date fields may not allow this change. Tape then tells you to add a new date field.

Why doesn't my date show in the calendar?

Turn on Show in calendar in the field settings. Learn more about your personal calendar →

Can I filter or sort records by a date?

Yes. Views can filter, sort, and group by date fields. Learn more about filtering views →

Can an automation react to a date?

Yes. An automation can start when a date arrives. Learn more about the date trigger →

Are there other field types?

Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?