Dates not sorting full string

[ndroark]

Summary

In some cases, dates in the Date Created field fomatted as yyyy-mm-dd are only sorting by part of the string. Example here: https://wabash.hykucommons.org/collections/d4efac9d-24d2-472e-85cd-1c7da1319ccd?utf8=%E2%9C%93&sort=date_ssi+desc&per_page=10&locale=en

Relevant Slack thread: https://assaydepot.slack.com/archives/C0313NKC08L/p1708455332886429

Acceptance Criteria

• Date Created field is sorted by its entire string

Testing Instructions

• Create two works
• Put the dates as something like 2009-10-01 and the other 2009-09-01
• Add them to a collection
• Go to the collection show page and sort the works by date created
• Observe that the dates sort correctly

[jillpe]

SoftServ QA: ✅

It did sort the works correctly via the date created. Work 1 973's created date was 2009-10-01. #973 Work 2 SoftServ QA's created date was 2009-09-01

Collection created for QA

[ndroark]

In this collection (https://wabash.hykucommons.org/collections/d4efac9d-24d2-472e-85cd-1c7da1319ccd?utf8=%E2%9C%93&sort=date_ssi+desc&per_page=10&locale=en), works with properly structured dates are still sorting the days out of order.

[laritakr]

The reindex did not complete correctly.

second = SolrDocument.find('1e392dac-37de-4d57-aa40-83020bbae320')
irb(main):008:0> second['date_ssi']
=> "2001"

GenericWork.find(second.id).update_index
irb(main):013:0> second['date_ssi']
=> "2001-01-18"

[ShanaLMoore]

We reindex the collection of concern and see the issue got resolved so perhaps there were some issues when we reindexed before. We will need to run another reindex over the weekend.