Columbia
Escutcheon Columbia University Libraries Digital Program
APIS Date Conventions

          Path: Digital Library Projects  : APIS : Date Conventions


The purpose of date normalization is to allow for a general date search function in the APIS interface.

The tables to the left show sample textual "modern dates" from Phase II APIS records, along with the normalized date equivalents that were either automatically generated or hand-edited from them for loading into the central APIS database.


Recommended Date Normalization

*BCE: Use minus sign for BCE dates

*For items dated to a specific year, enter that year in Date1 and leave Date2 blank, e.g. "ca. 257 B.C."
   dd046 | 1 | = -257
   dd046 | 2 | =

* For items dated to either one year or another year, enter both years as Date1 and Date2 respectively, e.g., "June/July 95 or 62 B.C"
      dd046 | 1 | = -95
      dd046 | 2 | = -62

* For items known or likely to be from within a span of dates, put the earliest possible date as Date1 and the latest possible date as Date 2, e.g., "Between 180 and 192 A.D"
      dd046 | 1 | = 180
      dd046 | 2 | = 192

* CE: for items originating within a span of dates within a single century, if actual dates are not used, use the following approximations:

-"Early"
     dd046 | 1 | = [YY]00
      dd046 | 2 | = [YY]25
-"1st half"
      dd046 | 1 | = [YY]00
      dd046 | 2 | = [YY]50
-"Middle"
      dd046 | 1 | = [YY]50
      dd046 | 2 | =[none]
-"2nd half"
      dd046 | 1 | = [YY]50
      dd046 | 2 | = [YY]99
-"Late"
      dd046 | 1 | = [YY]75
      dd046 | 2 | = [YY]99

* CE: For items dated to within a single CE century, use the beginning and end dates of the century. For the beginning date, start with the zero year (except for 1st Century CE, for which begin with "1"), e.g., "VIIth cent. A.D."
      dd046 | 1 | = 600
      dd046 | 2 | = 699

* BCE: for items originating within a span of dates within a single century, if actual dates are not used, use the following approximations:

-"Early"
     dd046 | 1 | = -[YY]99
     dd046 | 2 | = -[YY]75
-"1st half"
      dd046 | 1 | = -[YY]99
      dd046 | 2 | = -[YY]50
-"Middle"
      dd046 | 1 | = -[YY]50
      dd046 | 2 | = -[none]
-"2nd half"
      dd046 | 1 | = -[YY]50
      dd046 | 2 | = -[YY]00
-"Late"
      dd046 | 1 | = -[YY]25
      dd046 | 2 | = -[YY]00

* BCE: For items dated to within a single BCE century, use the beginning and end dates of the century. For the beginning date, start with the 99th year; for the end date, use the zero year (except for 1st Century BCE, for which begin with "1"), e.g., "IIIrd cent. B.C."

     dd046 | 1 | = -299
     dd046 | 2 | = -200

 

Sample Date Conversions

BCE Dates dd046 | 1 | dd046 | 2 |
113/112 B.C. -113 -112
251(?) B.C. -251 [none]
spring of 240 B.C. -240 [none]
ca. 257 B.C.(?) -257 [none]
about 242 B.C. -242 [none]
IInd or Ist cent. B.C. -199 -1
Late second century B.C -125 -100
IIIrd cent. B.C -299 -200
IIIrd/IInd cent. B.C. -299 -100


CE Dates dd046 | 1 | dd046 | 2 |
Ist cent. A.D. 1 99
Ist-IInd cent. A.D. 1 199
IInd Cent. A. D. 100 199
Early IInd Cent. A. D. 100 150
1st half of the IInd cent. A.D. 100 150
2nd half of the IInd cent.A.D. 150 199
Latter half of IInd cent. AD 150 199
Middle or late IInd cent. A.D. 150 199
IInd-IIIrd cent. A.D. 100 299
IInd/IIIrd. cent. A.D. 100 299
IInd or IIIrd cent. A.D. 100 299
IInd or early IIIrd cent. A.D. 100 250
Late IInd/IIIrd cent. A.D. 175 299
IIIrd cent. 200 299
(Early) IIIrd cent. A.D. 200 225
IIIrd/IVth cent. A.D. 200 399
IIIrd-IVth cent. A.D.(?) 200 399
IIIrd or IVth Cent. A. D. 200 399
Late IIIrd/early IVth cent. A.D. 250 350
Late IIIrd or early IVth cent. A.D. 250 350
between 381 and 431 A.D. 381 431
IVth cent. A.D. 300 399
IVth/Vth cent. A.D. 300 499
Vth cent. A.D.? 400 499
Vth Cent. A. D. 400 499
VIth Cent. A.D. 500 599
VIth/VIIth cent. A.D. 500 699
VIIth cent. A.D. 600 699
VIIth/VIIIth cent. A.D 600 799
7th or 8th Cent. A. D. 600 799
ca. Sept. 46 A.D. 46 46 [none]
29-30 A.D. 29 30
14-37 A.D. (reign of Tiberius) 14 37
25 February - 26 March, 203 A.D. 203 [none]

Columbia Libraries    Digital Program
Last revision: 05/22/03
© Columbia University Libraries