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 and time

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 the date and time fields

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.

By selecting the “Include time” option, a date field can also keep a timestamp (in 12- or 24-hour format). You can manually select a time from the drop-down menu or enter a specific time with this option selected.

You can edit your field by clicking the dropdown beside the field you want to change and click ‘Edit field’, then Change button.

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 that each row was created will always be the same.

enter image description here

Last modified

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 fields 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 will reflect the time that the undo action was carried out rather than the value of last modified date that was there prior to 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!