True that Excel doesn't recognize dates before 1901, but you can convert them using formulas like "YEAR", "RIGHT", etc.
Its a little work, but depending on how well you know Excel, one could easily set up a macro to convert the direct output from Legacy into readable formats. I do this to create a "census index" and other files I use to track what information I have and need. The GenViewer option sounds even easier, and I'll look into that. If you already have Excel you can accomplish this without additional cost, but paying $30 or whatever GenViewer costs may be the better option. Scott On Fri, Jul 30, 2010 at 10:56 AM, Sherry/Support <she...@legacyfamilytree.com> wrote: > Unfortunately, Excel doesn't recognize dates earlier than 1901. There > is a freeware add-in called XDate which you can use for that. > > Also, the other problem is that there are so many ways dates are shown > in Legacy - month and year only, year only, date and month only, etc, > that the sort doesn't work well either. > > The best way to sort on dates is using GenViewer, a Mudcreek Software > program, which we sell in the online store. You can do all kinds of > sorts which you can't do in Legacy, as well as searches, and print the > results out. > > > > Sincerely, > Sherry > Technical Support > Legacy Family Tree > > > > On Fri, Jul 30, 2010 at 6:56 AM, Scott Hall <seh0...@gmail.com> wrote: >> I think the easiest is to download the list into Excel, if you have the >> program, and sort from there. >> >> Under the individual list you can click "Print" and select "save as CSV". >> You can select any column to be included, including death date. >> >> Scott >> >> On Fri, Jul 30, 2010 at 7:38 AM, Mike Evans <michael.evan...@btinternet.com> >> wrote: >>> >>> Hello listers >>> >>> Can anyone advise please how to produce a list of individuals by 'death >>> date'. The purpose being to simplify a search for wills. >>> Have tried so many lists and reporting options but nothing found to date. >>> Many thanks. >>> Mike >>> >>> > > > > Legacy User Group guidelines: > > http://www.LegacyFamilyTree.com/Etiquette.asp > > Archived messages after Nov. 21 2009: > > http://www.mail-archive.com/legacyusergroup@legacyusers.com/ > > Archived messages from old mail server - before Nov. 21 2009: > > http://www.mail-archive.com/legacyusergr...@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 after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergr...@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
