Thanks, Richard. I'm wrestling with a spreadsheet that I've used to track what documents are missing for my direct line ancestors. Might just need to break down and take a closer look at LTools--I'm a few releases behind. --Paula
________________________________ From: Richard Van Wasshnova <[email protected]> To: [email protected] Sent: Saturday, August 30, 2014 12:01 PM Subject: Re: [LegacyUG] Sorting by date of birth Forget Excel. MS Access and ltools sort dates perfectly. No query needed, Just sott on tblIR.birthsd. -- Richard Van Wasshnova On Sat, Aug 30, 2014 at 8:14 AM, Paula Ryburn <[email protected]> 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 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
