Date and Time Fields

The date field type displays values as dates or times. Baserow date and time fields allow users to track and organize events, deadlines, and appointments in a clear and organized way. With date and time fields, users can easily create calendars, reminders, and schedules that can be shared with teams, clients, or stakeholders.

In this section, we will explore the different types of date and time fields available in Baserow, how to set them up, and how to use them effectively to streamline your workflow and keep everyone on the same page.

Adding date field

To add a date field,

  1. Click the plus sign + to the right of your existing fields.
  2. Select the date type and name the field. You can add a unique field name in the customisation menu and choose a date format by clicking the Date format dropdown menu.
  3. Click Create

enter image description here

You can manually enter a date (and time) into a cell, or you can use the calendar picker to quickly choose a recent date. The calendar and time picker makes it easy to choose a certain day and time when updating a date or time.

You can format the date field, and insert an automatically updated timestamp based on a selected timezone.

enter image description here

Format a date and time field

You can modify the format of the date when you customise the date and time formats. From the field options, you can change how the date field values are formatted, choose your preferred date format, and decide whether or not to include a time.

Edit your field by clicking the dropdown beside the field you want to change and click Edit field, then the Save button.

Setting a date format

Any datetime field has the potential to be set to a date format. You can set your preferred date format from the drop-down options in the field configuration menu.

  • European DDMMYYYY (20/02/2020)
  • US MMDDYYYY (02/20/2020)
  • ISO YYYYMMDD (2020-02-20)

enter image description here

Setting a time format

Any date field can include a timestamp. You can include time for a datetime field by selecting the “Include time” option from the field configuration menu.

You’ll be able to select your preferred time format from the drop-down options.

  • 24-hour format (23:00)
  • 12-hour format (11:00 PM)

By selecting the “Include time” option, you can manually select a time from the drop-down menu or enter a specific time.

enter image description here

Created on

When creating a new field type, you can set it to display the date and time when a row was created. The date (and, optionally, the time) that a row was created will be automatically displayed in the Created on field type.

Note that there is no way to directly modify the data in the cells in the Created on field because the date each row was created will always be the same.

enter image description here

Last modified field

The last modified field will always be the most recent date and time that a row was edited by a user. The computed field automatically returns the date and time of the last modification.

enter image description here

Learn more about the last modified field.

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.