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/legacyusergroup@legacyfamilytree.com/
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/legacyusergroup@legacyfamilytree.com/
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/legacyusergroup@legacyfamilytree.com/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp