handling incomplete dates

[Alan Harvey]

Greetings,

I'm converting a 16K-record Excel file, containing herbarium plant  
collection data, to Panorama. One important piece of data is when a  
specimen was collected, but not all specimens have complete dates,  
i.e., sometimes they have the month and year but no day, sometimes  
not even the month is known. This is more common with older  
collections. The person who originally entered the data dealt with  
this in a variety of ways ("0/4/32", "April 1932", etc.), all of  
which is flagged as problematic data when I try to convert this field  
to a date field. Makes sense, but even so, is there any way to  
include partial dates in a date field?

Thanks in advance,

Alan
____________
Alan W. Harvey
Associate Professor
Department of Biology - 8042
Georgia Southern University
Statesboro, GA 30460
phone (912) 681-5784
fax (912) 681-0845
http://www.bio.georgiasouthern.edu/bio-home/harvey/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080109/b425d587/attachment.html