Datatypes › date

Date as DDMONYY

ID date_dmony

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 a two-digit day, the three-letter English month abbreviation in upper case and a two-digit year, without separators, as in 06NOV26. It is the DATE7. format of SAS and appears in exports of systems that use it. The century has to be inferred.

Pattern of
Date date
Categories
Date and time
Countries
Global (not tied to a country)
Languages
English
Quality
75/100 · missing: mapping (Wikidata, Schema.org, ...), translation, detector coverage
Metacrafter rules
no detection rule yet
Supported by tools
no tool record lists this type yet

Regular expression

^(?:0[1-9]|[12]\d|3[01])(?:JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)\d{2}$

Python re syntax.

Examples

ValueDescription
06NOV266 November 2026
31DEC9931 December 1999
06NOV2026 invalidFour-digit year (DATE9.)
6NOV26 invalidDay without a leading zero

Sources

Use this record