Dataverse: Sorting guestbook responses by date doesn't sort chronologically

[jggautier]

When viewing guestbook responses in the table, clicking on the Date header doesn't sort guestbook responses by date chronologically. Seems like it's sorting the characters alphabetically by month, then numerically by date and year.

I could see this on Harvard Dataverse and Demo Dataverse.

Sorting by other columns does seem to work.

[pdurbin]

This issue was estimated as a "1" and the easiest one-line I could come up with is in pull request #4400 which is to simply use ISO 8601 format (i.e. 2018-01-08) and continue to sort by strings.

It looks like this:

ISO 8601 is the XKCD way! https://xkcd.com/1179/

Moving to Code Review at https://waffle.io/IQSS/dataverse

[mheppler]

Highly related to Date/Time Stamp Format - Consistency Across App #1391.

[mheppler]

In today's status mtg I proposed apply the same sort bug fix to the table on the Manage Templates pg. If it is a similar one line fix, we should try to kill two birds. (See my comment above for link to related issue about the inconsistent date display formats.)