dates field in in the news - there are a lot of different date formats entered for the "Article date" field. Examples 01-05-1992066-02-1996Dec 5, 1993. I am not sure why we didn't make this a date field to begin with, but can we clean up these dates and then make a date field? (Note, we my then need to create a formula field to format the dates into plain YYYY-MM-DD format)
how should we use the "complete" field? I had assumed that we shouldn't create a record at all if the field is not marked "complete" but on the works table, very few items are marked complete. Should complete only be taken into account for certain tables?
I am guessing that we only index people who are "major african poets" - do they also need to be marked as "complete"?
at least one person appears to be duplicated - we will probably want a cleanup stage to look for these and reassign as needed. Currently both of these will be indexed as a person record
01-05-1992
066-02-1996
Dec 5, 1993
. I am not sure why we didn't make this a date field to begin with, but can we clean up these dates and then make a date field? (Note, we my then need to create a formula field to format the dates into plain YYYY-MM-DD format)Existing data