A Date Range field holds a start date and an end date together. Think of the two dates on a hotel booking: check-in and check-out.

Here is the test: does the answer have a start and an end? If yes, you want a Date Range field. For a single date, use a Date field. For a deadline that tracks completion, use a Due Date field.

Example: an Audits table with a field called Audit Fieldwork Window. Each audit shows the days the auditors are on site, so the team sees every engagement as a bar in Timeline View and spots the overlaps.

The Audit Fieldwork Window field in an audit record, showing a partly filled pill with the start and end dates.

The field settings panel opens. It has three tabs: Settings, Defaults and Help Text. There is no AI Field Agent tab on this field. The rest of this article takes the tabs in that order. Save at any point with Add Field (or Update Field on a field that already exists) and come back to the other tabs later.

The field settings panel, Settings tab, with the Display Format pill sample and the Require switch.

The Settings tab holds how the range looks and one rule. Top to bottom: Display Format and Options.

How the range looks in a record and in views. The dropdown shows a sample; open it to see the four options, each with a live sample.

The pill is full for a range in the past and gray for one not yet started. Hover over it to see the number of days, such as 9 days. Audit Fieldwork Window keeps Pill, so a glance at the grid shows how far through fieldwork each audit is.

The Display Format dropdown open, showing the Compact, Standard, Long and Pill cards with their samples.

Require an entry in this field. Off to start. On, the field shows a REQUIRED label, and a record cannot be saved until a range is entered. For Audit Fieldwork Window it is on: an audit with no window is an audit nobody has scheduled.

Default Date Range is the range every new record starts with. It reads No Default Date to begin with. The other options are Today, Today Plus and Specific Date.

Audit Fieldwork Window has no default, because each audit's window comes from the plan. A field such as Review Period might start at Today.

A note for the person filling in the record, up to 800 characters. Help Text Appearance shows it As A Tooltip (the default, behind an info icon next to the field name) or Below The Field Name (always visible).

Write it for someone who has never seen the field. For Audit Fieldwork Window: "The first and last day the auditors are on site. Take both from the engagement letter."

Field Permissions. Every field can carry its own permissions, which control who can see the field and who can edit it. Open the column menu and select Edit Field Permissions. Let the audit lead set Audit Fieldwork Window while everyone else reads it. See Field Permissions.

Dynamic Record Permissions. A Date Range field can also drive record-level rules: who can see or edit a record based on the value it holds. Every field type except Button can drive a rule. See Dynamic Record Permissions.

Once ranges are entered, the field answers "when, and for how long?" across the table.

In a record, the field is a gray bar that reads Select Date Range. Select it to open the picker: a start box, Add Time under it, and an arrow to Add End Date. Pick or type the start date, then the end date; the span lights up in the calendar, and the x next to the end date clears it. Select Done, then save the record. In Grid View, an empty cell shows a dashed calendar icon, and a saved cell shows the range in the chosen format.

The picker tidies what you enter. Start after end: the dates are swapped. Only a start: the end gets the same date. Only an end: the start becomes today. Add Time adds a time to each date from a list in 15-minute steps, or type one.

The Date Range picker open on a record, with the start and end dates chosen, the span highlighted and the Done button.

Timeline View draws each audit as a bar from its start to its end, so overlapping fieldwork shows at once. See Timeline View.

Add the filter from the view toolbar and pick Start or End. "Audit Fieldwork Window Start is within the next 30 days" lists the audits about to begin. Start and End each offer is, is not, is before, is after, is on or before, is on or after, is empty and is not empty. The value can be a date or a relative one, such as today or a number of days ago.

Group a view by Start, by End or by the whole range. The column menu's Group by this Field and the toolbar both do it.

Sort from the view toolbar and pick Start or End. The column menu has no sort entry for this field.

A Lookup field can show the range on a linked record, and Lookup filters see it as Date Range Start and Date Range End. The field also works in an Auto-Generated Title. In Grid View, the column footer can show Earliest Date, Latest Date and Date Range. A Rollup cannot read a Date Range field; a Rollup combines number fields only.

A formula can read the field. Formula Functions & Operators lists the date functions.

There is no separate date-based trigger. The triggers are record created, record updated, record matches a condition, form submitted, scheduled time and button clicked. In each of them, Start and End are date conditions: equals, not equals, before, after, on or before, on or after and is empty. See Automation Actions explained.

Add the field to a Form View and the respondent submits a start and an end. The field shows in the Display Format set on it, Add Time appears after a date is picked, and the field works in read-only forms. See Form View.

Change one date. Open the picker from the record, pick the new start or end, and select Done.

Add or change a time. Open the picker, select Add Time under the date, and pick from the list or type the time. The dates stay.

Change the display format. Open Modify Field Settings, pick another format under Display Format, then Update Field. Every record shows the new format; the stored dates do not change.

Change the field type. A Date Range field can become a Text, Text Area, SmartDoc or Due Date field. See Changing a Field's Type.

Last verified 1 Nov 2026.