Date Range Fields

Learn about Date Range fields in Noloco tables

Date Range fields are configured to hold start and end dates, defining the duration of an event with values like '2023-09-25 to 2023-09-30'. It's a combination of two Date Fields.

They can be used with the calendar or timeline view as the start and end dates for the events.

Components

A Date Range field stores:

• Start Date: When the event or period begins

• End Date: When the event or period ends

Both dates can include time information depending on your configuration.

Use Cases

Date Range fields are perfect for:

• Event scheduling (conferences, meetings, workshops)

• Project timelines and milestones

• Vacation and leave tracking

• Booking and reservation systems

• Campaign durations

• Rental periods

• Contract terms

Integration with Views

Date Range fields work excellently with:

• Calendar views to show events with proper start and end times

• Timeline views for project management, scheduling and Gantt-style planning with dependencies

• Filtering to find overlapping periods or events within date ranges

Best Practices

• Ensure end dates are after start dates through validation rules

• Consider timezone handling for multi-day events

• Use Date Range fields instead of separate start/end date fields for better data integrity

• Date ranges display more intuitively in calendar and timeline views than separate date fields

• Consider default durations for common event types (1 hour meetings, full-day events, etc.)