Date/time

The date/time data type stores dates. This is important when using components, or displaying information that relies on time/dates. A calendar component, for example, will utilize the date field. With Budibase, you can also provide an earliest and latest date, within your date/time data type. This allows you to add additional validation so dates added have to fall after, before, or in between the earlier and latest dates. The date's within Budibase comply with ISO8601 formating - 2020-09-24T13:12:04.622Z. Thankfully, we have a date picker that removes the need for data entry and makes life easier.

Creating a date/time column

The process for creating a date column takes a few seconds.

1. First, click the Create New Column button

2. Give your column a name - we used Date Started in the video above.

3. Choose date/time as your data type

4. Add an earliest or latest date - we added an earliest date

5. Click Save Column

6. Add data to your new column by adding rows

Using the date/time data type

In the Design section, you can pull in information from your date/time column, using the Repeater component and binding.