FW: Patron Birthdate

[David Ruml <David.Ruml@xxxxxxxxxx>]

Oops.  Sorry.  I didn't notice that it was the FIXED field that was being
discussed.  We have our patron birthdate in a variable field.  Please ignore
my previous post.  I'll read more carefully next time.

David

-----Original Message-----
From: David Ruml 
Sent: Monday, March 17, 2003 8:52 AM
To: 'innopac@xxxxxxxxxx'
Subject: RE: Patron Birthdate


I checked our database, and we have several patrons who were born in 1932.
We don't seem to have a problem storing that year.

DAVID E. RUML
Carrollton Public Library
Carrollton, Texas

-----Original Message-----
From: Martha Driscoll [mailto:driscoll@xxxxxxxxxx]
Sent: Monday, March 17, 2003 8:44 AM
To: innopac@xxxxxxxxxx
Subject: Patron Birthdate


We just turned on the patron birthdate field and have been in the process 
of moving the date that we stored in a note field into this fixed field.  
We noticed that everyone who was born in 1932 did not store the date, 
although you could type it in the field.  If you save the record and go 
back in, then the date is blank.

The helpdesk says that the system can't store 1932 because '32' is the 
ASCII character for a blank.  Does anyone else think it strange that a 
database cannot store the year 1932?  I tried 2032 and that does store ok.  
What do the rest of you do with your 71-year-old patrons?

-- 
Martha Driscoll, Systems Manager
North of Boston Library Exchange (NOBLE)
driscoll@xxxxxxxxxx
Ph: 978-777-8844  Fax: 978-750-8472

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac