Skip to main content

Date Field: add and format dates and times

Add a Date field, pick Compact, Standard or Long display, add a time in 15-minute steps, and use it in Calendar and Timeline views.

Written by Emma Montgomery

A Date field stores a date and, if you add one, a time. You add the time to each value with + Time in the date picker. Add it like any field, choose a Compact, Standard or Long display format, and Calendar and Timeline views pick it up automatically.

Plan Availability

All plan types

Permissions

Workspace Admins, Solution Creators and Solution Managers: Can create, modify, delete, and manage Date fields in their solutions.

Platform

Web

Related Reading


What does a Date field store?

The Date field captures date and time values in SmartSuite tables. Formats for date and time dynamically adjust based on locale settings defined in the Member Profile.


How do I add a Date field?

From Grid View

  1. Click the "+" menu icon after the last column header.

  2. Alternatively, open the Column Menu by clicking on a column header's dropdown icon and select "Add Field to the Right."

  3. Select "Date" from the list. Use the search bar to quickly locate it.

  4. Configure the field settings in the pop-up window and select Add Field.

    The Add Field menu in Grid View with Date Field selected

From Record View

  1. Open a record in your table.

  2. Click the "+" icon next to an existing field to add a new field below.

    An open record with the plus icon beside a field for adding a Date field below it

How do I enter and format dates?

Enter or change a date

  1. Double-click the cell where you want to add a date (a single click only selects it).

  2. A date picker opens. Select the year, month and day, or type the date (for example 3.15.24), then select Done.

  3. Optionally, add a time (see How do I add a time?).

    The calendar picker open on a date cell with year, month, day and optional time

Display format and required setting

  1. Open the field's column menu and select Modify Field Settings.

  2. Change the display name or select a format using the "Display Format" dropdown.

  3. Choose Compact (10/28/2026 at 11:11 AM), Standard (default, Oct 28 at 11:11 AM) or Long (Wed, Oct 28 at 11:11 AM). Standard and Long hide the year for dates in the current year.

  4. Turn on Require an entry in this field to make the field required. A "Required" label shows next to the field, and a record with an empty date cannot be saved ("Date is required").

    The Date field settings with the Display Format dropdown showing Compact, Standard and Long
  5. Default Date (Defaults tab): No Default Date, Today, Today Plus a number of days (1 to 999) or a Specific Date. It fills new records only. See Default Text/Values in Fields.

  6. AI Field Agent: turn on Enable AI Field Agent to let SmartSuite AI fill in the field.

  7. Help Text: a note shown as a tooltip or below the field name. See Adding/Modifying Field Help Text.

  8. Select Update Field to save the changes.

Check out quick articles on Setting Default Field Values and Adding Help Text to fields.

How do I add a time?

To add a time to each date:

  1. Open the date picker, select a date, then select + Time.

  2. Choose a time from the 15-minute increment dropdown or manually type in a specific time.

    The + Time button in the date picker with the 15-minute time list

How do Calendar and Timeline views use Date fields?

Calendar View

  • Calendar View automatically detects Date fields.

  • Records are mapped to calendar dates. Use By in the toolbar to choose the date field, or select + Add another field to show several date fields.

    A Calendar View with the Date selector for switching between date fields

Timeline View

  • Timeline View recognizes date-related field types (e.g., Date, Due Date, and Date Range).

  • Records appear on the timeline. In By, choose the start date field, an optional end date field and the bar color.

    A Timeline View with records placed by their date values

How do I sort, filter and group by a Date field?

Sort 1 → 9 puts empty values first, then oldest to newest. Filter operators: is, is not, is before, is after, is on or before, is on or after, is empty, is not empty.

Filter values include Today, Tomorrow, Yesterday, Exact Date/Range, the previous, current or next week, month, quarter or year, and the next or past number of days. Group creates one group per day; the time is ignored. Date fields also work in Spotlight and Find.

Grid footer: Earliest Date, Latest Date and Date Range show the date span of the column.


Where else can I use a Date field?

Date fields can be used in Formula fields (for example YEAR([Date])), Lookup fields, the filters of Lookup, Count and Rollup fields, and Auto-Generated Titles.

Change type: a Date field can be changed to Text, Text Area, SmartDoc or Due Date. See Changing a Field's Type.


What are common ways to use Date fields?

1. Project deadlines

Scenario: A project management team needs to track deadlines for multiple tasks.

Solution: Use the Date Field to set due dates for each task and visualize them in Calendar View.

2. Event scheduling

Scenario: An events team needs to plan and organize a series of webinars.

Solution: Use the Date Field to input event dates and times.

3. Employee timesheets

Scenario: An HR team needs to log work hours for employees.

Solution: Use two Date fields with a time (for example Start and End) to record start and end times for accurate tracking.


Frequently asked questions

How do I stop the field from showing a time?

The time is set for each value. Open the date picker and select the x next to the time to remove it.

Why does my date show in US (or UK) format?

Date and time formats follow the locale set in your Member Profile, so each member sees dates in their own format. The stored value is the same for everyone.

How do I set the time zone for a Date field?

Times display according to the locale and time settings in each member's profile rather than a per-field setting.

How do I get records on my calendar in time order?

Add a time to the date on each record (select the date, then + Time). Calendar View places the record on its date, and Day view orders records by time.

Do I need a start date for Timeline View?

Timeline View reads Date, Due Date and Date Range fields. To show a span rather than a point, use a Date Range field, a Due Date with a start date, or add an end date field in By.

Last verified 29 Oct 2026.

Did this answer your question?