Date and Time Fields

The date field type displays values as dates or times.

You can quickly enter a date and a time, if required, into a cell using a date field. You can format the date field, and insert an automatically updated timestamp based on a time zone.

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) when adding a date, 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.

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 MMDDYYY (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

When a new blank row is created, the last modified and created on field types will be the same values, until a user makes a modification.

A row’s last modified field value never rolls back in time. If you alter a cell and then undo that modification, a row’s last modified field will reflect the time that the undo action was carried out rather than the value of the last modified date that was there before completing the action that was undone.

enter image description here

Track last modified date and time on computed fields

You can choose to restrict the field so that it only displays the most recent time a particular field was modified. The date functions in formulas can also be used to return the date and time of the most recent user modification. Using the date functions in formulas, you can specify one or more field names to track modification and return the date and time of the most recent change made to any of the specified fields.

Both the formula function and the last modified field type reflect recent changes to editable fields by a user. They do not capture changes made automatically in any fields, such as formula fields, where the user does not directly modify the cell values but rather uses Baserow to compute the values.

If you add or remove a row from a link to table field, the last modified data will change. However, if the data linked to the link to table field change, the latest modified time will not change. Although the connected row’s values in the other table have changed, you haven’t altered which row you are linking to. Changing the link to table row’s fields that are stored in a different table won’t affect the last modified value.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!