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 <[EMAIL PROTECTED]>
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
_____________________________________________________________________
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/
_____________________________________________________________________
Date: Tue, 29 Apr 2008 21:19:33 -0500
To: LegacyUserGroup@legacyfamilytree.com
Subject: Re: [LegacyUG] Date Formats in CSV
From: [EMAIL PROTECTED]
Thank you to everyone who responded, but once again, I apparently was
not
clear.
I have Legacy set to display dates as "29 Nov 1847." I can enter
"11/29/1847" and it will format the date as per my settings, i.e., "29
Nov
1847." However, the date is apparently stored as "11/29/1847"in Access
and in the CSV file it is displayed as "11/29/1847."
Because I have been inconsistent in my data entry, since no matter how I
entered it the date was displayed as per my options, I have a mess of
different formats in the CSV file, i.e., "24 June 1843", "02/04/1947",
"February 23 1845."
I'm using OOo's Calc, not Excel, and it isn't having any problem with
the
years -- they are displayed as I entered them originally.
On Tue, 29 Apr 2008 16:27:52 -0500, Brian Johnson
wrote:
Or use Calc which is the OpenOffice spreadsheet. It has no problem with
dates.
Brian
2008/4/29 Don Brown :
This issue came up a while ago. Visit
http://j-walk.com/ss/excel/files/xdate.htm and check out a file called
"XDate". This small program adds new functionality to Excel 97 and
later.
--
Don Brown
Orangeville, Ontario, Canada
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages:
http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp