search

robcrothall / history

Kowie Museum History project
0 stars 0 forks source link

Fix dates to use leading zeros for month and day #27

Open robcrothall opened 5 years ago

robcrothall commented 5 years ago

Data capturers have entered dates without a leading zero for month and day in dates. This causes the events to be displayed out of sequence. Fix it in the spreadsheet reformatting programs, the history update, and in dates already imported.

robcrothall commented 5 years ago

Try to fix the dates, but where it doesn't match any expected format, use it as it is. Use the primary key (ID) to sequence the rows.