Paula I use LTools and I use a COPY of my Legacy Database and run this SQL;
UPDATE tblIR SET UserRef = tblIR.BirthSD WHERE BirthSD > 0 Which sets the UserRef field to be equal to what is in Legacys Birth Sort date field. (except when there is no date in the field) Then I open that copied database Then in Legacy Index view, change the Column configuration to include the User Ref field and change the sort by to UserRef (instead of sort by RIN) You can then have an index view that looks something like http://www.1familytree.com/genealogy/1ft_tempshow.php I hope that helps Jay On Sun, Sep 7, 2014 at 2:09 PM, Paula Ryburn <[email protected]> wrote: > Thanks, Cheryl, for the formatting suggestions. Unfortunately, I have > dates from before 1900 and after 1900, and one cell format works for the > former & not the latter, while another works for the latter & not the > former. And I don't want to re-export & import it all. Disappointing, but > will work with what I have now & test a few things before I do it again... > if I remember the Excel glitch by that time. Short memory these days. ;) > --Paula > > ------------------------------ > *From:* singhals <[email protected]> > *To:* [email protected] > *Sent:* Sunday, August 31, 2014 10:01 AM > *Subject:* Re: [LegacyUG] Sorting by date of birth > > Birth year is in a separate column; mark it in the > spreadsheet with a ' in front to the machine thinks it's an > alpha-num field not a date field. Or, highlight the whole > column and format it as numeric, not date. At least, both > those work on my version of Xcel for me. > > Cheryl > > Paula Ryburn wrote: > > Hey, Pat, I wanted to share with you what I just > > re-discovered about Excel: It can't handle dates earlier > > than 1900. I knew this, but had forgotten! I was doing just > > what I suggested you do, and I ran into all sorts of date > > format issues in Excel. *sigh* You'd think they could fix > > that, but no. So, I'm guessing sorting your whole database > > by birth DATE could get a bit messy in Excel. Or maybe there > > is a way to set your date format parameter in Legacy before > > you export that would put the dates in the integer format in > > the CSV file...? I may have just crossed over my techie > > limit line. --Paula > > > > ------------------------------------------------------------ > > *From:* Paula Ryburn <[email protected]> > > *To:* [email protected] > > *Sent:* Thursday, August 28, 2014 8:05 PM > > *Subject:* Re: [LegacyUG] Sorting by date of birth > > > > Pat, What are you trying to discover or do? Would printing a > > birthday list help? It's called the Calendar Creator now, > > under Other Reports. > > Otherwise, the export to .csv and import into Excel is the > > route I would take. --Paula > > > > > > > > ------------------------------------------------------------ > > *From:* Pat Hickin <[email protected]> > > *To:* [email protected] > > *Sent:* Sunday, August 24, 2014 7:45 PM > > *Subject:* [LegacyUG] Sorting by date of birth > > > > > > Is there any way to sort the entire database by, e.g., date > > of birth?? > > > > Thanks, > > Pat > > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <http://www.legacyfamilytree.com/Etiquette.asp> > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <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/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com). > 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/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
