1250 Date Time Period Format Qualifier

Code indicating the date format, time format, or date and time format

Type

Identifier (ID)

Length

Min 2 / Max 3

Codes

CC

First Two Digits of Year Expressed in Format CCYY

The first two characters in the year CCYY

CD

Month and Year Expressed in Format MMMYYYY

Date expressed as Month, Month, Month, all upper case alpha and Year, Year, Year, Year e.g., JAN 1994, FEB 1994, etc

CM

Date in Format CCYYMM

CQ

Date in Format CCYYQ

Date expressed as Year, Year, Year, Year, e.g., 1996, and Q as quarter within that year

CY

Year Expressed in Format CCYY

D6

Date Expressed in Format YYMMDD

D8

Date Expressed in Format CCYYMMDD

DA

Range of Dates within a Single Month Expressed in Format DD-DD

DB

Date Expressed in Format MMDDCCYY

DD

Day of Month in Numeric Format

The numeric day of the month expressed using a lead zero if the number of the day is less than ten

DT

Date and Time Expressed in Format CCYYMMDDHHMM

EH

Last Digit of Year and Julian Date Expressed in Format YDDD

KA

Date Expressed in Format YYMMMDD

Date expressed as Year, Year, Month, Month, Month, Day, Day, e.g., 94JAN01

MD

Month of Year and Day of Month Expressed in Format MMDD

MM

Month of Year in Numeric Format

The month of the year consecutively numbered from one for January to twelve for December and expressed using a lead zero if the number of the month is less than ten

RD

Range of Dates Expressed in Format MMDDCCYY-MMDDCCYY

TC

Julian Date Expressed in Format DDD

TM

Time Expressed in Format HHMM

Time expressed in the format HHMM where HH is the numerical expression of hours in the day based on a twenty-four hour clock and MM is the numerical expression of minutes within an hour

TQ

Date Expressed in Format MMYY

TR

Date and Time Expressed in Format DDMMYYHHMM

TS

Time Expressed in Format HHMMSS

Time expressed in the format HHMMSS where HH is the numerical expression of hours in the day based on a twenty-four hour clock, MM is the numerical expression of minutes within an hour, and SS is the numerical expression of seconds within a minute

TT

Date Expressed in Format MMDDYY

TU

Date Expressed in Format YYDDD

UN

Unstructured

YM

Year and Month Expressed in Format YYMM

YY

Last Two Digits of Year Expressed in Format CCYY

The year in the century (00 to 99)

DDT

Range of Dates and Time, Expressed in CCYYMMDD-CCYYMMDDHHMM

DTD

Range of Dates and Time, Expressed in CCYYMMDDHHMM-CCYYMMDD

DTS

Range of Date and Time Expressed in Format CCYYMMDDHHMMSS-CCYYMMDDHHMMSS

MCY

MMCCYY

RD2

Range of Years Expressed in Format YY-YY

RD4

Range of Years Expressed in Format CCYY-CCYY

RD5

Range of Years and Months Expressed in Format CCYYMM-CCYYMM

RD6

Range of Dates Expressed in Format YYMMDD-YYMMDD

RD8

Range of Dates Expressed in Format CCYYMMDD-CCYYMMDD

A range of dates expressed in the format CCYYMMDD-CCYYMMDD where CC is the first two digits of the calendar year, YY is the last two digits of the calendar year, MM is the month (01 to 12), and DD is the day in the month (01 to 31); the first occurrence of CCYYMMDD is the beginning date and the second occurrence is the ending date

RDM

Range of Dates Expressed in Format YYMMDD-MMDD

RDT

Range of Date and Time, Expressed in Format CCYYMMDDHHMM-CCYYMMDDHHMM

A range of dates and times expressed in the format CCYYMMDDHHMM-CCYYMMDDHHMM where CCYY is the numerical expression of the century CC and year YY, MM is the numerical expression of the month within the year, DD is the numerical expression of the day within the month, HH is the numerical expression of hours in the day based on a twenty-four hour clock, and MM is the numerical expression of minutes within an hour; the first occurrence of CCYYMMDDHHMM is the starting time and the second is the ending time

RMD

Range of Months and Days Expressed in Format MMDD-MMDD

RMY

Range of Years and Months Expressed in Format YYMM-YYMM

RTM

Range of Time Expressed in Format HHMM-HHMM

A range of times expressed in the form HHMM-HHMM where HH is the numerical expression of hours in the day based on a twenty-four hour clock and MM is the numerical expression of minutes within an hour; the first occurrence of HHMM is the starting time and the second is the ending time

RTS

Date and Time Expressed in Format CCYYMMDDHHMMSS

YMM

Range of Year and Months, Expressed in CCYYMMM-MMM Format