Yes -- the CSV file was generated by Legacy. Here are a few of lines from
it:
Abernathy, Clayton [246] Mar 1891
Adams, Marie [199] 11/11/1806 05/11/1884
Adkins, Andrew Jackson [635] 08/29/1856 06/13/1932
Adkins, David [637] Jun 1854 10 March 1905
Adkins, Della May [393] 03/08/1896 10/31/1982
These dates display in the "DD MMM YYYY" format, however, in Legacy.
I'm beginning to think I'm just jinxed.
On Tue, 29 Apr 2008 21:50:13 -0500, JLB <[EMAIL PROTECTED]> wrote:
This CSV file you're talking about: Is it generated by Legacy and
therefore based on your date settings there? I don't think it's
possible to get a csv output in some other format than what Legacy is
set for. So I'm trying to imagine what else is going on there. I"ve
tried entering dates in different formats, watching Legacy correct them
and then looking for a 'mess' in a csv file. There just isn't one.
--
JL
JLog - simple computer technology for genealogists
http://www3.telus.net/Jgen/jlog.html
Kris wrote:
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 <[EMAIL PROTECTED]>
wrote:
Or use Calc which is the OpenOffice spreadsheet. It has no problem
with dates.
Brian
2008/4/29 Don Brown <[EMAIL PROTECTED]>:
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/[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
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
