Random Date Generator for Testing: Create Reliable Test Dates

Which Dates Should a Test Dataset Include?

A useful test set is not just a long list of ordinary dates. It contains values from several categories, each designed to challenge a different rule. Start with normal dates, then add boundaries, leap years, duplicate values and invalid inputs.

Use valid and invalid dates for different purposes

A random date generator should normally return valid dates. That makes it suitable for positive tests, sample data and realistic fixtures. Negative tests require intentionally invalid values such as 2026-13-01, 2025-02-29, malformed text, impossible ranges and missing fields. Keep these two datasets separate so a failure is easy to diagnose.

Check both ends of every date rule

If a booking system accepts dates from today through 12 months ahead, test today, tomorrow, the final allowed date and one day beyond it. Random dates inside the range can confirm ordinary behavior, but only deliberate boundary values prove that the limits are enforced correctly.

How to Generate a Random Date in Code

The safest general approach is to convert the allowed range into a count of days, select an integer offset, and add that offset to the start date. This avoids generating the year, month and day separately, which can produce impossible combinations.

Random date generator for testing in JavaScript

This function returns a uniformly selected UTC calendar date. Both the start and end dates are eligible.

function randomIsoDate(startIso, endIso) {
  const dayMs = 86_400_000;
  const start = Date.parse(`${startIso}T00:00:00Z`);
  const end = Date.parse(`${endIso}T00:00:00Z`);

  if (!Number.isFinite(start) || !Number.isFinite(end) || start > end) {
    throw new Error("Enter a valid date range");
  }

  const days = Math.floor((end - start) / dayMs);
  const offset = Math.floor(Math.random() * (days + 1));
  return new Date(start + offset * dayMs).toISOString().slice(0, 10);
}

console.log(randomIsoDate("2025-01-01", "2026-12-31"));

JavaScript Date values represent milliseconds from the Unix epoch. Math.random() is suitable for ordinary test data but not for passwords, tokens or security decisions.

Random date and time in JavaScript

function randomDateTime(start, end) {
  const first = new Date(start).getTime();
  const last = new Date(end).getTime();

  if (!Number.isFinite(first) || !Number.isFinite(last) || first > last) {
    throw new Error("Enter a valid date-time range");
  }

  const value = first + Math.floor(Math.random() * (last - first + 1));
  return new Date(value).toISOString();
}

console.log(randomDateTime(
  "2026-01-01T00:00:00Z",
  "2026-12-31T23:59:59Z"
));

Random date generator for testing in Python

Python can choose an inclusive day offset with randint(), then add it using timedelta.

from datetime import date, timedelta
from random import randint

start = date(2025, 1, 1)
end = date(2026, 12, 31)

if start > end:
    raise ValueError("Start date must not be after end date")

day_offset = randint(0, (end - start).days)
result = start + timedelta(days=day_offset)

print(result.isoformat())

See the official Python documentation for the random module and datetime types. The standard pseudo-random generator is designed for simulation and sampling, not cryptographic security.

Random date generator for testing in Java

import java.time.LocalDate;
import java.util.concurrent.ThreadLocalRandom;

LocalDate start = LocalDate.of(2025, 1, 1);
LocalDate end = LocalDate.of(2026, 12, 31);

long firstDay = start.toEpochDay();
long lastDayExclusive = end.toEpochDay() + 1;

long selectedDay = ThreadLocalRandom.current()
    .nextLong(firstDay, lastDayExclusive);

LocalDate result = LocalDate.ofEpochDay(selectedDay);
System.out.println(result);

Oracle describes LocalDate as a date without a time or time zone, which makes it a natural choice for birthdays and other date-only fields.

Random date generator for testing in C#

DateOnly start = new(2025, 1, 1);
DateOnly end = new(2026, 12, 31);

if (start > end)
    throw new ArgumentException("Start date must not be after end date");

int availableDays = end.DayNumber - start.DayNumber;
DateOnly result = start.AddDays(Random.Shared.Next(availableDays + 1));

Console.WriteLine(result.ToString("yyyy-MM-dd"));

The .NET documentation explains the exclusive upper limit used by Random.Next() and the date arithmetic performed by DateOnly.AddDays().

Random date formula in Excel or Google Sheets

=RANDBETWEEN(DATE(2025,1,1),DATE(2026,12,31))

Format the result cell as a date. Microsoft notes that RANDBETWEEN returns a new value whenever the worksheet recalculates. If you need a stable fixture, copy the generated cell and paste it as a value.

Random date generator for testing in SQL

This PostgreSQL example chooses a date from an inclusive range:

SELECT DATE '2025-01-01'
       + FLOOR(
           RANDOM() * (
             (DATE '2026-12-31' - DATE '2025-01-01') + 1
           )
         )::INTEGER AS random_date;

For database-specific behavior, check the documentation for your engine. PostgreSQL documents both its random() function and its date and time operators.

Common Random-Date Testing Mistakes

Frequently Asked Questions