Date (and time) field
  • 22 Feb 2023
  • 1 Minute to read
  • Dark
    Light

Date (and time) field

  • Dark
    Light

Article Summary

A date field allows you to easily enter a date—and optionally a time—into a cell.

Adding dates

When editing a date, you can manually enter a date or use the calendar widget to easily select a recent date. Note that we do not currently support dates before 1/1/0000.

360082530174ScreenShot2020-08-03at103834AM.png

In the field customization menu you can customize the name of your field, and select a date format by clicking the Date format dropdown menu.

360082530374ScreenShot2020-08-03at104046AM.png

360082530514ScreenShot2020-08-03at104227AM.png

Include a time field

A date field can also store a timestamp (in 12- or 24-hour format) by toggling on the "Include a time field" option. With this option toggled on, you can manually select a time from the dropdown menu (shown in 30-minute increments), or enter in a specific time.

1500018244981settime.gif

Use the same timezone for all collaborators

Collaborators working together in the same base can, and will, see different dates and times unless a specific timezone has been specified (on a field-by-field basis). By toggling the option to "Use the same time zone for all collaborators", users can choose their desired timezone from a drop-down list. GMT/UTC will be chosen by default.

To provide better clarity in your base around which timezone a field is set to, we recommend also toggling the "Display time zone" option at the bottom of the configuration menu. This will show the abbreviation for your specified timezone next to the time in each cell for that field.

Working with timezones is covered in more detail in this article.

Changing the default pre-set date formatting for new date fields

A newly-created date field's default format will attempt to use your browser's local language when selecting the local format for dates. For example, the local browser language setting for this browser was set to "English (United States)":

4405234438295demodatefieldlocal.jpg

We can then see if we change the browser's language setting to "English (United Kingdom)", a newly created date field will use a different local formatting:

4405235946263demodatefieldukformatting.jpg


Was this article helpful?