The millennium bug is back with a vengeance, after programmers in the 1990s simply pushed the problem back by 20 years

Note about data, windows, openrefine from _drafts, a blog of notes, solutions, and mini-workshops to get things started.

Dates appear regularly in research data and metadata but are a problematic data type to normalize due to a variety of potential formats. This suggests an opportunity for data librarians to assist with formatting dates, yet there are frequent examples of data librarians using diverse strategies for this purpose. Instead, data librarians should adopt the international date standard ISO 8601. This standard provides needed consistency in date formatting, allows for inclusion of several types of date-time information, and can sort dates chronologically. As regular advocates for standardization in research data, data librarians must adopt ISO 8601 and push for its use as a data management best practice.

ISO 8601 was published on 06/05/88 and most recently amended on 12/01/04.