I have created a text column to have the year of the original publication.
In principle I fill it with the pubdate date, and then I correct it if necessary in cases like these:
Dates before our era: -150
Books containing several works with a date range: 1850-65
Hence the need for it to be a text column.
|