Kris, For some reason best known elsewhere, the last part of my previous email was curtailed and should have read ( I know what's going on - it decided it was html!):
This is the sentence I do not get: "I now have, basically, garbage for dates in my CSV file." How are you reading your CSV ie. what software? I cannot understand how one would get a different presentation of the dates, though, except in Excel with dates before 1900. Ron Ferguson _____________________________________________________________________ New Blog: Free Contacts Database for use with Open Office http://www.fergys.co.uk 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 11:20:54 +0100 > > > 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 > > > _________________________________________________________________ Play the Andrex Hello Softie Game & win great prizes http://www.thehellosoftiegame.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
