If what I think is happening is, the problem is in Excel, assuming that is what you are using, and not legacy. Your spreadsheet date format will not accept dates before 1900 and depending on spreadsheet format for dates, will do funny things with them. If you can be more specific with the details of your problem perhaps I can help more. Also changing the column format to text is a work-around. Can't help pre 1900 dates however that is a MS Excel date handling problem.
Regards, Steve Stevens -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of JLB Sent: Tuesday, April 29, 2008 2:27 PM To: [email protected] Subject: Re: [LegacyUG] Date Formats in CSV This is my experience: All dates entered in the Individual information screen will be a consistent format which you can choose under Customize/Dates. If you haven't chosen anything it will be doing something anyway by default. You can change the format on all of them at the click of a button. Dates entered in the Source Detail box, for instance, will be whatever you've entered. They don't adjust automatically as above. I, too, was inconsistent in this one case and changed them all manually. I was able to shorten the process somewhat by finding dates that repeated in many places and using Search & Replace to change them. For example April 29, 2008 changed to 29 April 2008. I must be missing something in your question as you suggest that the CSV export somehow overrides what Legacy has done to make your dates consistent. -- JL JLog - simple computer technology for genealogists http://www3.telus.net/Jgen/jlog.html Kris wrote: > I've been lazy entering my dates and never gave it a second thought > since Legacy formats them so beautifully for me. However, I realize > now the error of my ways since I exported to a CSV file and my dates > are a mess -- an accurate mess, but a mess. > > Since the dates were exported in the same way as they were entered, > i.e., MM/DD/YYYY or DD Mon YYYY, whatever felt right at the time, > apparently, I have several different date formats in my CSV file and > the spreadsheet I'm importing it to is giving me dirty looks. > > Is there any easy way to fix this? Or do I just need to go back, fix > them all, and strive for consistency in the future? > > Thanks! > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: > http://www.mail-archive.com/[email protected]/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > > > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.6/1402 - Release Date: 4/28/2008 1:29 PM No virus found in this outgoing message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.6/1402 - Release Date: 4/28/2008 1:29 PM Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
