Date Format Guide

ISO 8601 is the international standard for representing dates and times. The date-only form is YYYY-MM-DD: a four-digit year, two-digit month, and two-digit day separated by hyphens. June 15, 2026 is written 2026-06-15.

ISO 8601 is unambiguous in any locale. 2026-06-15 cannot be mistaken for the 6th of an imaginary month 15, because the largest month number is 12 and the format always puts year first. Most programming languages, databases, and APIs prefer or require this format.

The full datetime form adds a time component and a timezone designator: 2026-06-15T14:30:00Z means 2:30 PM UTC on June 15, 2026. The Date Format Converter accepts and outputs ISO 8601 alongside other formats.

When you paste a date into a spreadsheet or database import and it shows the wrong month, check whether the source was ISO order (YYYY-MM-DD) and the target parsed it as a different format.

The US format is MM/DD/YYYY: month first, day second, four-digit year, forward slashes as separators. 06/15/2026 is June 15, 2026 in US convention. Two-digit years (06/15/26) are still common on paper forms but ambiguous in software.

The UK and most of Europe use DD/MM/YYYY: day first, month second, year. 15/06/2026 is also June 15, 2026 in UK convention. 06/07/2026 means July 6 in the US but June 7 in the UK—the ambiguity is real and causes errors in shared documents.

The safest rule in any cross-border context: write the month as a word or three-letter abbreviation (Jun 15, 2026 or 15 Jun 2026) so the order is obvious regardless of locale.

When you receive a date file from a different country and the values look plausible in both formats, look for dates where day > 12. A value like 25/06/2026 can only be DD/MM/YYYY because month 25 does not exist—so the format is DD/MM.

Long-form dates write the month as a full word: June 15, 2026 (US) or 15 June 2026 (UK). These are unambiguous and preferred for formal documents, legal filings, and correspondence where clarity matters more than brevity.

Abbreviated formats use a three-letter month abbreviation: Jun 15, 2026 or 15 Jun 2026. The abbreviation removes month/day order ambiguity without the full word length.

Some systems use ordinal-day formats—Day 166 of 2026 or Julian date 2026166—primarily in astronomy, logistics, and manufacturing. These do not map directly to calendar months without conversion.

Fiscal calendar formats number weeks or periods from a company-specific start date. These are internal conventions and require knowing the fiscal year start before conversion.

A Unix timestamp is the number of seconds (or milliseconds in some systems) since midnight UTC on January 1, 1970. 1750032000 represents a specific instant in 2026. Timestamps are timezone-independent and sort correctly as integers.

Timestamps appear in log files, API responses, database columns, and wherever systems need a compact, unambiguous representation of a moment in time. The Unix Timestamp Converter converts between a timestamp and a human-readable UTC date.

Millisecond timestamps are thirteen digits instead of ten. If a timestamp looks unusually large—like 1750032000000—it is likely milliseconds rather than seconds. Divide by 1000 to get the Unix second value.

Timestamps always represent UTC. When displaying a timestamp to a user, you must convert to their local timezone—the Timezone Converter shows how an instant differs across time zones.

The Date Format Converter on DateToolsHQ accepts a date in any supported format and outputs the same date in ISO 8601, US, UK, and long-form representations. Use it when you need to standardize dates from a file or source that uses an unfamiliar pattern.

For Unix timestamp conversion specifically, the Unix Timestamp Converter accepts a Unix second or millisecond value and displays the UTC date, or accepts a date and outputs the timestamp.

Spreadsheet date serial numbers—where 1 equals January 1, 1900 in Excel or January 1, 1904 in some Mac spreadsheets—are different from Unix timestamps. They are not directly interchangeable without knowing which epoch the file uses.

Date format errors in imports are easier to catch before the import than after. If a batch of dates will move between systems, run a sample through the Date Format Converter and compare source and target representations before processing the full file.

The Days Until Calculator counts calendar days to any future date—or how many days ago a past date was—with an optional include-today setting for planning.

Countdown To Date adds an optional UTC time, event name, and hour/minute updates when you need more detail than calendar days alone.

Seasonal pages target the next occurrence automatically: Valentine's Day (February 14), Mother's Day (second Sunday in May), Independence Day (July 4), Halloween (October 31), Thanksgiving (fourth Thursday in November), Black Friday (the following Friday), Cyber Monday (the Monday after Thanksgiving), Easter Sunday (Gregorian), Christmas (December 25), and New Year's Day (January 1).

For a live second-by-second display with hours and minutes, use the Countdown Timer when the target includes a specific time of day in UTC.