Datatypes › date

Date as DDMMYYYY

ID date_dmy_compact

Pattern of dateNot PIIDraft

This record is a draft: it has not been reviewed yet and may be incomplete or wrong. Do not rely on it for compliance decisions. Help improve it (see CONTRIBUTING.md).

Calendar date written as eight digits without separators: two-digit day, two-digit month and four-digit year, for example 25122024. A column of such values is easy to take for integers.

Pattern of
Date date
Categories
Date and time
Countries
Global (not tied to a country)
Languages
Common to most languages
qddate pattern
dt:date:date_5
Quality
100/100
Metacrafter rules
no detection rule yet
Supported by tools
qddate

Regular expression

^(?:0[1-9]|[12]\d|3[01])(?:0[1-9]|1[0-2])\d{4}$

Python re syntax.

Examples

ValueDescription
2512202425 December 2024
050520225 May 2022
20241225 invalid
25.12.2024 invalid

Translations

LanguageNameDescription
RussianДата в формате ДДММГГГГКалендарная дата из восьми цифр без разделителей: день, месяц и год, например 25122024.

Sources

Use this record