Hello Rose,
Your own formats are not quite standard. See http://en.wikipedia.org/wiki/ISO_8601 and http://stackoverflow.com/questions/1912894/c-sharp-convert-datetime-to-iso-format-yyyy-mm-dd-hhmmss
Warmest regards,
Dom Benson
--
Electronic Resources Librarian, Brunel University Library, Uxbridge, Middlesex, UB8 3PH, UK
From: kbart_interest@xxxxxxxxxxxxx [mailto:kbart_interest@xxxxxxxxxxxxx] On Behalf Of Rose Nelson
Sent: 01 June 2012 17:48
To: kbart_interest@xxxxxxxxxxxxx
Subject: [kbart_interest] Date format on KBART compliant lists
Hello,
I’m not quite sure who to address this question to so I thought I’d send it to the general KBART list. The CO Alliance of Research Libraries developed an ERMS, Gold Rush back in 2001 and now we license this software to libraries outside of our consortium. I was very excited to discover so many new title lists in standard format available from the KBART website. This is a great improvement. However, I noticed that several publishers still use non-standard date formats (unrecognizable by Excel) for coverage dates. Before we load these title lists into Gold Rush, we have to manually correct coverage dates. The non-standard format which I am referring to is yyyy-mm e.g. 2010-12. It would be MUCH better if publishers were willing to put dates in one of the multitude of standard Excel formats such as yyyy, mm/dd/yyyy, mm-dd-yyyy. Even the alpha numeric dates that Gale Cengage works can be converted to a numerical date by our loader.
What is the likelihood of developing a more structured date standard for KBART lists? It seems to me that it would be easier for the publishers and ERMS providers to use standard dates. I’m not sure why so many have adopted the non-standard format. I was really hoping that with KBART dates would be standardized across the board.
Any updates or discussion on this topic is greatly appreciated.
Thanks,
Rose Nelson
Systems Librarian/Gold Rush Project Manager
CO Alliance of Research Libraries
3801 E. Florida Ave. Ste 515
Denver, CO 80210
303-759-3399 X103
Fax 303-759-3363
KMLM List