How to use Date Test Data Generator
- Set the date range and the number of random dates.
- Pick a format (or write a custom pattern such as DD/MM/YYYY HH:mm).
- Keep the edge cases on for boundary testing.
- Press Generate and export.
Date Test Data Generator features
- Random dates between two bounds, optionally with time of day and chronological order
- 22 edge cases: epoch, Y2038, leap days, non-leap centuries, Excel and Windows epochs, DST transitions, leap second, 0001 and 9999 limits
- Formats: ISO date, ISO date-time, US, EU, Unix seconds/ms, RFC 2822, long, tabular Hijri and custom token patterns
- Each row includes ISO, Unix, weekday, weekend flags (Sat–Sun and Fri–Sat), leap-year flag and Hijri equivalent
- Seedable; JSON, CSV, SQL, XML, JSON Lines or table output
Date Test Data Generator example
Custom pattern with edge cases
Input:
From 2024-01-01 to 2024-12-31 · Format: Custom "DD MMM YYYY" · Edge cases: onOutput:
value,iso,note
19 Jan 2038,2038-01-19T03:14:07.000Z,Max signed 32-bit Unix time (Y2038)
29 Feb 2024,2024-02-29T00:00:00.000Z,Leap day
14 Mar 2024,2024-03-14T00:00:00.000Z,Frequently asked questions about Date Test Data Generator
Which edge cases are included?
Unix epoch and the second before it, Y2038 rollover, leap days (2000, 2024), non-leap 1900 and 2100, Excel and Windows epochs, Y2K, DST transitions, a leap-second boundary and the 0001/9999 year limits.
What formats can I output?
ISO date, ISO date-time, US and EU order, Unix seconds and milliseconds, RFC 2822, long form, tabular Hijri and a custom token pattern (YYYY, MM, DD, HH, mm, ss…).
How accurate is the Hijri date?
It uses the arithmetic (tabular) Islamic calendar, which matches the Umm al-Qura calendar on most days but can differ by one day around month boundaries.
Why are weekend flags given twice?
isWeekend covers Saturday–Sunday and isFriSatWeekend covers Friday–Saturday, the weekend used across most of the Gulf.