Actually the Legacy database ALREADY contains the sorted birth dates in a field called BIRTHSD in the Indivdual's record in the tblIR. There is also the sorted Death date in DeathSD and BurialSD for sorted burials.
From: Heather Stovold Sent: Friday, October 23, 2009 3:53 PM To: LegacyUserGroup@legacyfamilytree.com Subject: Re: [LegacyUG] Favorite Features Yes, it is more dificult.... I recognized that. However - if the programmers are already doing a secondary sort on dob (the primary sort being on Name - and Sherry from Legacy said that Legacy does the secondary automatically when you are sorting by name for all names that are the same) - they obviously have the code available to sort the dates (even the non-standard ones) .... so that makes it pretty trivial to this programmer mind. On Fri, Oct 23, 2009 at 11:37 AM, Mike Fry <mike...@iafrica.com> wrote: Heather Stovold wrote: Thanks Sherry - the problem is we would rather be able to sort by the DOB column (or potentially any column shown) so that we can look for people with the same or similar birth dates that don't have the same name. I know if it was a standard date field it would probably be trivial code - but I do recognize that genealogy dates are not in a standard date field. And dates taken from the GRO are definitely non-standard, being entered as <month> Q <year>, where <month> is Mar or Jun or Sep or Dec. A standard can not be used for this since the <month> Q combination is shorthand for 1 <month> - 2 to <last day> <month>. Definitely *not* a trivial exercise for the programmers :-) 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