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.
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 calendarturned 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 accessto the database app and a desktop or tablet.
Add a date field
Open the database app, open the app menu, and select
Customize record layout.Click
+or type/in a text block.Under
New field, selectDate.Click the drag handle (
⋮⋮) of the new field and selectEdit field.
Date field settings
In Edit field, you find:
Time:Hidden,Shown, orRequired. WithRequired, a date needs a time.End date:Hidden,Shown, orRequired. WithRequired, start and end date are both needed.Date format: how the date is written. ChooseFull date,Long date,Short date,Numeric, orRelative.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.
Default dates
Under Default, choose:
None: the field starts empty.Now: the moment the record is created. This option appears only whenTimeis 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.
Change how dates look in a layout
In Edit field display, you can override the format for one layout:
Date format:Autouses the field setting. You can also pickFull date,Long date,Short date,Numeric,Relative,MM/DD/YYYY,DD/MM/YYYY, orDD.MM.YYYY.Time format:Auto,12 hours, or24 hours.
FAQs
Can I add a time to a date later?
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?
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?
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?
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?
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?
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 →.
