In-depth practical guides

Normalise dates in a source dossier

Separate calendar dates, local times and instants before sorting records or converting to UTC.

Updated :

Do these timestamps describe the same instant?

Publication, effective and access dates have different roles. Retaining role and precision prevents a misleading chronology; normalisation does not certify the producer’s clock.

  1. Keep original text

    Record field, language, convention and role. Keep 2026-10 as a month; do not invent a day or hour.

  2. Identify the offset

    Z or +02:00 locates an instant. Local time needs a zone and date-specific rules; a country or your computer’s setting is insufficient.

  3. Preserve ambiguity

    03/04/2026 needs the producer’s convention. Clock changes can repeat or skip local times; record uncertainty instead of silently choosing.

  4. Retain precision

    Keep original, normalised value, zone, offset and rule version. Sort determined instants separately from calendar dates.

Normalise a date list

Processed in your browser; values are not sent to the server. One value per line, up to 100 lines. Examples are calculation cases.

Ready to check the examples.

Supported: YYYY-MM-DD, partial year or month, and timestamps with seconds and Z or ±HH:MM offset. Fractions of 1–9 digits are retained. Local times are not converted; leap seconds need separate treatment. Input order is preserved.

Situations and decisions

Typical situations for preparing a check. They do not describe completed assignments or actual observations.

Same instant

Calculation example: 2026-01-15T10:00:00+02:00 equals 2026-01-15T08:00:00Z.

Date without time

2026-01-15 is a calendar date. Midnight UTC would add information the source never supplied.

Record to retain

  • Original text, field and date role.
  • Precision, explicit offset or identified zone.
  • Normalised value, convention and rule version.
  • Ambiguities, partial dates and refused conversions.

Official references

Related source profiles

Related protocols

Checks before reaching a conclusion

  • Is each date’s role explicit?
  • Is the offset sourced?
  • Is original precision retained?
  • Are ambiguous values kept out of instant sorting?

Frequently asked questions

May I use my computer’s time zone?

Only when evidence establishes that it is the zone of the event. The reader’s setting does not establish the source’s local time.

What does -00:00 mean?

RFC 3339 uses it for an unknown local offset when UTC time is known. Preserve that status instead of treating it as evidence of a local zone.

TOOLS / REGISTERS

Write a record

Keep original, normalised value, zone, offset and rule version. Sort determined instants separately from calendar dates.

  • Access date and time zone
  • Exact URL
  • Exact column name
  • Observed passage / value
  • Event, publication and observation dates
  • Logical type and format
  • Dataset / series code
  • Version / revision
  • Method / definition
  • Observed status
  • Limit / uncertainty
  • Decision / next action
  • Review owner
  • Next review