KMLM List

["Moss,Paul" <mossp@xxxxxxxx>]

I know this is not ideal, but when working with Excel, we have had some
success with people following this procedure:
Set the date format YYYY-MM-DD in Microsoft Excel:
1. Select the cells you want to format (cells with years, months, AND
days)
2. Right click on the selected cells and select "Format Cells..."
        a. In the Number tab under Category, select "Date"
        b. Under Locale (location), select "English (South Africa)" from
the 
drop down menu
        c. Under Type, select the format that matches "yyyy-mm-dd"

As Dom pointed out, the yyyy-mm-dd format is actually a more standard
way to represent dates in general even if it happens to not work very
well in Excel. 

As a side note, if you are doing extensive data manipulation, I would
strongly suggest switching away from Excel and using something like
OpenOffice.  Excel can damage files in unexpected ways, such as file
encodings and, as you can see here, date or other number formatting.
There are other applications that give you greater control over these
types of things, which can often help you to avoid some silly errors
that Excel may introduce.  This is just my $0.02.

--
Paul Moss
OCLC
614-761-5230


> -----Original Message-----
> From: kbart_interest@xxxxxxxxxxxxx
[mailto:kbart_interest@xxxxxxxxxxxxx] On
> Behalf Of Dominic Benson
> Sent: Friday, June 01, 2012 1:20 PM
> To: 'Rose Nelson'; kbart_interest@xxxxxxxxxxxxx
> Subject: [kbart_interest] RE: Date format on KBART compliant lists
> 
> 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-i
so-
> format-yyyy-mm-dd-hhmmss
> 
> Warmest regards,
> 
> Dom Benson
> --
> Electronic Resources Librarian, Brunel University Library
> <http://www.brunel.ac.uk/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
>