Date Schema Computations

IF

 

 

 

 

(always ignore)

 

 

 

THEN

Earliest and latest

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM-DD

 

1977

09

05

 

 

 

 

1977-09-05

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

11

16

 

 

 

 

2011-11-16

 

 

 

 

 

 

 

 

 

 

Earliest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM-DD

 

1977

09

05

 

 

 

 

1977-09-05

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

 

 

 

 

 

 

 

1977-09-05

 

 

 

 

 

 

 

 

 

 

Earliest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM

 

1977

09

 

 

 

 

 

1977-09-01

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

 

 

 

 

 

 

 

1977-09-30

 

 

 

 

 

 

 

 

 

 

Earliest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY

 

1977

 

 

 

 

 

 

1977-01-01

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

 

 

 

 

 

 

 

1977-12-31

 

 

 

 

 

 

 

 

 

 

Earliest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

with single qualifier

 

1977

09

05

 

+

5

YEARS

1977-09-05

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

 

 

 

 

 

 

 

1982-09-05

 

 

 

 

 

 

 

 

 

 

Earliest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

with dual qualifier

 

1977

09

05

 

+/-

5

YEARS

1972-09-05

USE MINUS

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

 

 

 

 

 

 

 

1982-09-05

 

 

 

 

 

 

 

 

 

 

Latest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM-DD

 

 

 

 

 

 

 

 

2011-11-16

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

11

16

 

 

 

 

2011-11-16

 

 

 

 

 

 

 

 

 

 

Latest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM

 

 

 

 

 

 

 

 

2011-11-01

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

11

 

 

 

 

 

2011-11-30

 

 

 

 

 

 

 

 

 

 

Latest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY

 

 

 

 

 

 

 

 

2011-01-01

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

 

 

 

 

 

 

2011-12-31

 

 

 

 

 

 

 

 

 

 

Latest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

with single qualifier

 

 

 

 

 

 

 

 

2006-11-16

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

11

16

 

-

5

YEARS

2011-11-16

 

 

 

 

 

 

 

 

 

 

Latest only

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

with dual qualifier

 

 

 

 

 

 

 

 

2006-11-16

USE ADD

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

11

16

 

+/-

5

YEARS

2016-11-16

 

 

 

 

 

 

 

 

 

 

Earliest and latest

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

Combination (e.g.)

 

1977

09

05

 

 

 

 

1977-09-05

 

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

 

 

 

 

 

 

2011-12-31

 

 

 

 

 

 

 

 

 

 

Earliest and latest

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM-DD

 

1977

09

05

 

-

5

DAYS

1977-08-31

with single qualifiers

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

2011

11

16

 

+

5

YEARS

2016-11-16

 

 

 

 

 

 

 

 

 

 

 

Earliest and latest

Earliest

Year

Month

Day

Certainty

Qualifier

Value

Unit

Scalar value

YYYY-MM-DD

 

1977

09

05

 

+/-

5

YEARS

1972-09-05

with dual qualifiers

Latest

Year

Month

Day

Certainty

Qualifier

Value

Unit

 

 

 

2011

11

16

 

+/-

5

MONTHS

2012-04-16

Notes

  • If +/- is used with an earliest date, compute as though it is a -
  • If +/- is used with a latest date, compute as though it is a +
  • If the year is not present, do not compute
  • If the year and day are present but no month, compute as the first of the year (ignore day and any month or day qualifiers)