Metacrafter Registry

Datatypes

Date

ID date

DatatypeNot PII

Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype.

Categories
Date and time
Countries
Global (not tied to a country)
Languages
Common to most languages
AutoType benchmark
date-chinese, date-d, date-hijri, date1, date10, date2, date3, date4
Microsoft CDM
means.measurement.date
Presidio
DATE_TIME
qddate pattern
dt:date:date_9
Quality
100/100
Metacrafter rules
6 rules (6 by field name, 0 by value)
Supported by tools
Alteryx Designer Cloud, Auto-Type, Amazon Comprehend, Azure AI Language PII detection, Collibra Data Classification, csv-detective, Dataiku DSS, DataPrep, Capital One DataProfiler, Google Data Studio, Great Expectations Semantic Types Expectations, IBM Knowledge Catalog (IBM watsonx.data intelligence), Metabase, metacrafter, Nightfall AI, OpenMetadata auto-classification, Oracle Analytics Desktop, Microsoft Presidio, qddate, Soda, Talend (Qlik Talend Data Preparation, Data Catalog and Data Inventory)

Regular expression

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

Python re syntax.

Examples

ValueDescription
2025-05-15ISO 8601 date
1993-12-30Date of a document in the register of cultural heritage objects
2025-13-01 invalidThere is no month 13
15.05.2025 invalidDay-first notation, the pattern date_dmy

Patterns

Specific representations of this datatype.

IDNameCategoriesCountriesDescription
date_bulgarian Date with a Bulgarian month name pattern draft datetime global Calendar date written in Bulgarian with the month name, day first, for example 5 май 2022 or 25 декември 2024, optionally followed by г....
date_cjk Date with year, month and day units (Chinese, Japanese) pattern draft datetime global Calendar date written in Chinese or Japanese as numbers followed by the units for year (年), month (月) and day (日, or 号 in spoken...
date_czech Date with a Czech month name pattern draft datetime global Calendar date written in Czech with the month name, day first, usually with a dot after the day and the month in the genitive case (5....
date_dmy Date in DD.MM.YYYY notation pattern draft datetime global Calendar date written as a two-digit day, a two-digit month and a four-digit year separated by dots, such as 31.12.2022. This day-first...
date_dmy_compact Date as DDMMYYYY pattern draft datetime global Calendar date written as eight digits without separators: two-digit day, two-digit month and four-digit year, for example 25122024. A...
date_dmy_dash Date as DD-MM-YYYY pattern draft datetime global Calendar date written as day, month and four-digit year separated by hyphens, for example 25-12-2024. It is not the ISO 8601 order,...
date_dmy_dash_yy Date as DD-MM-YY pattern draft datetime global Calendar date written as day, month and two-digit year separated by hyphens, for example 25-12-24. The century is not written and has to...
date_dmy_dot_yy Date as DD.MM.YY pattern draft datetime global Calendar date written as day, month and two-digit year separated by dots, for example 25.12.24, sometimes with a dot after the year...
date_dmy_slash Date as DD/MM/YYYY pattern draft datetime global Calendar date written as day, month and four-digit year separated by slashes, for example 25/12/2024, as in the United Kingdom and...
date_dmy_slash_yy Date as DD/MM/YY pattern draft datetime global Calendar date written as day, month and two-digit year separated by slashes, for example 25/12/24. The century is not written and has to...
date_dutch Date with a Dutch month name pattern draft datetime global Calendar date written in Dutch with the month name, day first: 5 mei 2022 or 5 mrt 2022, optionally after the weekday (donderdag 5 mei...
date_english Date with an English month name pattern draft datetime global Calendar date written in English with the month name, full or abbreviated, capitalised or in lower case. The day comes first (5 May...
date_french Date with a French month name pattern draft datetime global Calendar date written in French with the month name, day first: 5 mai 2022, le 5 mai 2022, 5 sept 2022, optionally after the weekday...
date_german Date with a German month name pattern draft datetime global Calendar date written in German with the month name, day first: 5. Mai 2022, 5 Mai 2022 or 5. Mär 2022, optionally after the weekday...
date_italian Date with an Italian month name pattern draft datetime global Calendar date written in Italian with the month name, day first: 5 maggio 2022 or 5 mag 2022, optionally after the weekday (giovedì 5...
date_korean Date with year, month and day units (Korean) pattern draft datetime global Calendar date written in Korean as numbers followed by the units for year (년), month (월) and day (일), for example 2024년 12월 25일. A...
date_mdy_slash Date as MM/DD/YYYY (United States) pattern draft datetime global Calendar date written as month, day and four-digit year separated by slashes, for example 12/25/2024, the usual numeric date in the...
date_mdy_slash_yy Date as MM/DD/YY (United States) pattern draft datetime global Calendar date written as month, day and two-digit year separated by slashes, for example 12/25/24, as in the United States. The century...
date_polish Date with a Polish month name pattern draft datetime global Calendar date written in Polish with the month name, day first, usually with the month in the genitive case (5 maja 2022), optionally...
date_portuguese Date with a Portuguese month name pattern draft datetime global Calendar date written in Portuguese with the month name, day first: 5 de maio de 2022, 5 maio 2022 or 5 mai 2022, optionally after the...
date_romanian Date with a Romanian month name pattern draft datetime global Calendar date written in Romanian with the month name, day first: 5 mai 2022 or, with an abbreviated month, 5 ian. 2022. The month is...
date_russian Date with a Russian month name pattern draft datetime global Calendar date written in Russian with the month name in the genitive case, day first: 5 мая 2022, 5 мая 2022 г. or 5 мая 2022 года,...
date_slovak Date with a Slovak month name pattern draft datetime global Calendar date written in Slovak with the month name, day first, usually with a dot after the day and the month in the genitive case (5....
date_spanish Date with a Spanish month name pattern draft datetime global Calendar date written in Spanish with the month name, day first, with or without the preposition de: 5 de mayo de 2022, 5 mayo 2022, 5...
date_turkish Date with a Turkish month name pattern draft datetime global Calendar date written in Turkish with the month name, day first, for example 5 Mayıs 2022, optionally followed by tarihinde or tarihli...
date_ukrainian Date with a Ukrainian month name pattern draft datetime global Calendar date written in Ukrainian with the month name, day first: 5 травня 2022 (genitive), 5 травень 2022 (nominative) or 5 трав. 2022...
date_ymd_compact Date as YYYYMMDD pattern draft datetime global Calendar date written as eight digits without separators: four-digit year, two-digit month and two-digit day, for example 20241225. This...
date_ymd_dot Date as YYYY.MM.DD pattern draft datetime global Calendar date written as four-digit year, month and day separated by dots, for example 2024.12.25.
date_ymd_slash Date as YYYY/MM/DD pattern draft datetime global Calendar date written as four-digit year, month and day separated by slashes, for example 2024/12/25, as often written in Japan.

Child datatypes

IDNameCategoriesCountriesDescription
birthday Birthday PII pii, datetime global A birthday is the anniversary of the birth of a person, or figuratively of an institution. Birthdays of people are celebrated in...
deathday Date of death PII pii, datetime global Date of death of the person

Translations

LanguageNameDescription
RussianДатаКалендарная дата. Регулярное выражение описывает форму ISO 8601 ГГГГ-ММ-ДД; другие нотации, например ДД.ММ.ГГГГ, описаны шаблонами этого типа.

Sources

Use this record