Hi Tom,
I think that most database date fields will only accept numerical characters so you would have to use a minus to represent BC dates.
For Glasgow Museums Collections Navigator (http://collections.glasgowmuseums.com) we use the minus within our CMS (Mimsy XG)date field and have some PHP code at the backend which translates the minus into a BC on screen...I don't really know of another way of doing it.
Hope this helps.
Best,
Kirsten
Kirsten H. F. Riley
Research Assistant - Collections Navigator Project Culture and Sport Glasgow
Email: [log in to unmask]
Phone: +44 (0) 141 276 9344
Fax:+ 44 (0) 141 276 9305
Mobile: +44 (0) 7921 237 923
Web:
http://collections.glasgowmuseums.com
****************************************************************
For mcg information visit the mcg website at
http://www.museumscomputergroup.org.uk
To manage your subscription to this email list visit
http://www.museumscomputergroup.org.uk/email.shtml
****************************************************************
|