Keydate: Difference between revisions

From GCD
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 3: Line 3:
* The YYYY represents the four-digit year the issue was published. If the publication date spans two years (e.g. December 1968-January 1969), use the first year.
* The YYYY represents the four-digit year the issue was published. If the publication date spans two years (e.g. December 1968-January 1969), use the first year.
* The MM represents the month. For bimonthly publications that list more than one month in their indicia (e.g. January-February 1955), the Keydate should be based on the first month. For quarterly publications, "Spring" issues should be indexed as "04", "Summer" issues should be indexed as "07", "Fall" issues should be indexed as "10", and "Winter" or "Holiday" issues should be indexed as "01" or "12", depending on whether they were published early or late in the year. If the month of publication is not known, either "00" or "13" may be used for MM. "00" is used for an issue published before issues for which a month is known, "13" is used for an issue published after issues for which a month is known.
* The MM represents the month. For bimonthly publications that list more than one month in their indicia (e.g. January-February 1955), the Keydate should be based on the first month. For quarterly publications, "Spring" issues should be indexed as "04", "Summer" issues should be indexed as "07", "Fall" issues should be indexed as "10", and "Winter" or "Holiday" issues should be indexed as "01" or "12", depending on whether they were published early or late in the year. If the month of publication is not known, either "00" or "13" may be used for MM. "00" is used for an issue published before issues for which a month is known, "13" is used for an issue published after issues for which a month is known.
* The DD represents the day. For a monthly series, DD is represented as a standard value of "00". If a series is published with a frequency greater than monthly, then the exact day of publication is indicated if it is known. For example, two consecutive issues of a biweekly publication might have the Keydates 2002.01.09 and 2002.01.23. If the exact day of publication is not known then "10" and "20" should be used on biweekly books, "10", "20", and "30" should be used on biweekly comics where the comic has three issues published during a month and "10", "20", "30", "40" and up to "50" should be used on weekly comics.
* The DD represents the day. If the exact day of publication is known, it should be included here.  Otherwise, for a monthly series DD is represented as a standard value of "00". For comics with a frequency greater than monthly where the exact day of publication is unknown, "10" and "20" should be used on biweekly books, "10", "20", and "30" should be used on biweekly comics where the comic has three issues published during a month and "10", "20", "30", "40" and up to "50" should be used on weekly comics.
* Some series such as Dell's Four Color have the keydates entered in by pattern, since the months of the individual issues are generally unknown.
* Some series such as Dell's Four Color have the keydates entered in by pattern, since the months of the individual issues are generally unknown.  If the keydate for an issue is already filled in and doesn't match the published date for the comic, the indexer should contact an editor to investigate whether it is one of these special patterns.
* Making sure that the issues in a series sort in the correct order is the most important thing in establishing the Keydates, but trying to get as close as possible to the actual publication date of a comic makes searching across series by date more likely to be correct
* Making sure that the issues in a series sort in the correct order is the most important thing in establishing the Keydates, but trying to get as close as possible to the actual publication date of a comic makes searching across series by date more likely to be correct
* Examples:
* Examples:

Revision as of 10:14, 28 April 2008

  • Required.
  • A 10 character code in the form YYYY.MM.DD, unique to every distinct issue in a series and used to represent the publication date of the comic for sorting purposes. This field is required for easy chronological sorting of issues, but is not shown in searches on the website.
  • The YYYY represents the four-digit year the issue was published. If the publication date spans two years (e.g. December 1968-January 1969), use the first year.
  • The MM represents the month. For bimonthly publications that list more than one month in their indicia (e.g. January-February 1955), the Keydate should be based on the first month. For quarterly publications, "Spring" issues should be indexed as "04", "Summer" issues should be indexed as "07", "Fall" issues should be indexed as "10", and "Winter" or "Holiday" issues should be indexed as "01" or "12", depending on whether they were published early or late in the year. If the month of publication is not known, either "00" or "13" may be used for MM. "00" is used for an issue published before issues for which a month is known, "13" is used for an issue published after issues for which a month is known.
  • The DD represents the day. If the exact day of publication is known, it should be included here. Otherwise, for a monthly series DD is represented as a standard value of "00". For comics with a frequency greater than monthly where the exact day of publication is unknown, "10" and "20" should be used on biweekly books, "10", "20", and "30" should be used on biweekly comics where the comic has three issues published during a month and "10", "20", "30", "40" and up to "50" should be used on weekly comics.
  • Some series such as Dell's Four Color have the keydates entered in by pattern, since the months of the individual issues are generally unknown. If the keydate for an issue is already filled in and doesn't match the published date for the comic, the indexer should contact an editor to investigate whether it is one of these special patterns.
  • Making sure that the issues in a series sort in the correct order is the most important thing in establishing the Keydates, but trying to get as close as possible to the actual publication date of a comic makes searching across series by date more likely to be correct
  • Examples:
* 1980.02.00 (for February 1980)
* 1945.01.00 (for January 1945)
* 2002.06.09 (for June 9, 2002)
* 1960.00.00 (for unknown date in 1960 or unknown date in the 1960s)
* 1953.04.76 (for Four Color issue #476)

(end of definition)


Definition currently under vote by the Senior Editors (April 15, 2008)

Current Schema: Issues table, Key_Date field