Kris, For some reason best known elsewhere, the last part of my previous email was curtailed and should have read:
This is the sentence I do not get:>I now have, basically, garbage for dates in my CSV file. View the Grimshaw Family Tree at: http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England See: http://myweb.tiscali.co.uk/fergys/ _____________________________________________________________________ > From: [EMAIL PROTECTED] > To: [email protected] > Subject: RE: [LegacyUG] Date Formats in CSV > Date: Wed, 30 Apr 2008 10:27:36 +0100 > > > Sorry, Kris but I still don't get it. > > Have a look at tblIR of your .fdb file in either Access or OOo Base and you > will see that the birth dates, for example, are stored as a formatted string > of numbers and how you actually put them in is unimportant, the format is > still the same. > > This is the sentence I do not get:>I now have, basically, garbage for dates > in my CSV file. > View the Grimshaw Family Tree at: > http://www.fergys.co.uk/Grimshaw/ > For The Fergusons of N.W. England See: > http://myweb.tiscali.co.uk/fergys/ > _____________________________________________________________________ > > > >> Date: Wed, 30 Apr 2008 01:54:04 -0500 >> To: [email protected] >> Subject: Re: [LegacyUG] Date Formats in CSV >> From: [EMAIL PROTECTED] >> >> Hi, Ron -- >> >> You aren't dense at all. As a matter of fact, you've hit the exact >> point. That *is* the way I actually entered the dates -- i.e., >> 11/24/1988. CSV didn't change anything -- and neither did Legacy. The >> *view* in Legacy is according to the Customize> Dates option. I enter >> "11/24/1988" in the Legacy field, hit tab, and the view in that field is >> changed to "24 Nov 1988" per my options. >> >> My question was, since I've entered the dates in so many different ways, I >> now have, basically, garbage for dates in my CSV file. Trying to change >> the format in those cells creates even more of a mess. The "11/24/1988" >> is okay -- but "Nov 1988" or "1788-1794" isn't. >> >> It really isn't that important and I'm not going to mess with it anymore. >> What I'm really using at this point in the CSV is the RIN and the name. I >> wanted the dates to help identify people with the same names, and wanted >> to find out if there was a quick fix for the dates for future reference in >> case I wanted to use them in a CSV in the future. >> >> Kris >> >> On Wed, 30 Apr 2008 01:24:14 -0500, ronald ferguson >> wrote: >> >>> Kris, >>> >>> It may be that I am particulatly dense this morningm but I really do not >>> see what you are getting at. No program stores a date in the way in >>> which you see it. The format which is visual is decided by the user. In >>> Legacy this is in Customise>Dates, as you know and in Open Office Calc >>> it is in Format>Cells>Numbers>Date. >>> >>> I do not know where to find it in Access. I have never come across >>> Saving As .CSV to change anything which has been entered >>> >>> >>> Ron Ferguson >>> _________________________________________________________________ Be a superhero and win! Play the Iron Man Mashup Game http://www.ironmanmashup.co.uk 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
