User Rating 0.0
Total Usage 0 times
Category Time & Date

Supported: YYYY-MM-DD, MM/DD/YYYY, DD.MM.YYYY, March 15, 2024

Presets:

No intervals added. Enter dates above to begin.

Is this tool helpful?

Your feedback helps us improve.

About

Date intervals compound complexity when unsorted. Project timelines, booking systems, and scheduling conflicts demand precise chronological ordering. Manual sorting invites errors - a single misplaced range cascades into scheduling collisions or resource conflicts. This tool parses intervals in ISO-8601 (2024-01-15), European (15.01.2024), and US (01/15/2024) formats, computing duration as d = end start in milliseconds, then converting to human-readable days and hours.

The sorting engine implements stable comparison: intervals with identical primary keys preserve input order. Overlap detection applies the intersection test where two intervals A and B overlap when Astart Bend Bstart Aend. Gap analysis identifies unoccupied periods between consecutive sorted ranges. Results persist locally, surviving browser sessions. Assumes all dates share a common timezone context - cross-timezone intervals require manual UTC normalization before input.

date sorter interval calculator date range timeline overlap detection duration calculator

Formulas

Interval duration is computed as the absolute difference between endpoint timestamps:

d = |tend tstart|

where tend and tstart represent Unix timestamps in milliseconds. Conversion to days applies:

ddays = d86,400,000

Two intervals A = [a1, a2] and B = [b1, b2] overlap when both conditions hold:

a1 b2 b1 a2

Gap detection between consecutive sorted intervals identifies unoccupied spans:

gap = Bstart Aend where gap > 0

The comparator function for stable sorting uses lexicographic ordering on selected keys:

cmp(A, B) =
{
−1 if Akey < Bkey1 if Akey > Bkey0 otherwise

where key {start, end, duration, label}.

Reference Data

Input FormatPatternExampleRegion
ISO-8601YYYY-MM-DD2024-03-15International
ISO with TimeYYYY-MM-DDTHH:MM2024-03-15T14:30International
US FormatMM/DD/YYYY03/15/2024United States
European FormatDD.MM.YYYY15.03.2024Europe
UK FormatDD/MM/YYYY15/03/2024United Kingdom
Long MonthMonth DD, YYYYMarch 15, 2024International
Short MonthDD Mon YYYY15 Mar 2024International
CompactYYYYMMDD20240315Technical
Sort CriteriaDescriptionUse Case
Start Date (Asc)Earliest start firstProject timelines, chronological review
Start Date (Desc)Latest start firstRecent-first analysis
End Date (Asc)Earliest end firstDeadline prioritization
End Date (Desc)Latest end firstLong-term planning
Duration (Asc)Shortest intervals firstQuick task identification
Duration (Desc)Longest intervals firstMajor project focus
Label (A-Z)Alphabetical by nameReference lookup
Duration UnitMillisecondsConversion
Second1,0001 s
Minute60,00060 s
Hour3,600,00060 min
Day86,400,00024 h
Week604,800,0007 d
Month (avg)2,629,746,00030.44 d
Year (avg)31,556,952,000365.25 d

Frequently Asked Questions

Intervals that share an exact boundary point (where A ends precisely when B starts) are classified as adjacent, not overlapping. The overlap condition requires strict inequality: A's end must exceed B's start for overlap to occur. The tool displays adjacent pairs separately from true overlaps.
The parser defaults to US format (MM/DD/YYYY) for slash-separated dates unless you specify otherwise in settings. European format (DD.MM.YYYY) uses dot separators. For unambiguous results, use ISO-8601 format (YYYY-MM-DD) which eliminates month/day confusion entirely.
Duration computes raw millisecond differences between timestamps. DST transitions may cause 23-hour or 25-hour days. For critical scheduling across DST boundaries, input times explicitly (e.g., 2024-03-10T01:00 to 2024-03-10T03:00 spans 1 hour due to spring-forward, not 2 hours). The tool displays actual elapsed time, not calendar arithmetic.
Yes. Zero-duration intervals (same-day events) are valid and sort by their date position. Duration displays as 0 days, 0 hours. This supports milestone markers or single-point events within a timeline.
The sorting algorithm preserves original input order for intervals with equal keys. If three intervals all start on 2024-01-15, they appear in the sequence you entered them. This stable sort property ensures predictable, repeatable results.
Gap analysis only identifies unoccupied time between non-overlapping consecutive intervals. Overlapping intervals produce no gaps in their shared region. The tool first sorts by start date, then scans sequentially - a gap exists only when interval B starts after interval A ends.