FAMILY-HISTORIAN-USERS-L Archives

Archiver > FAMILY-HISTORIAN-USERS > 2008-09 > 1221555917


From: "John James" <>
Subject: Re: [FHU] Defining Living Individuals
Date: Tue, 16 Sep 2008 10:05:17 +0100
In-Reply-To: <48CE7B7C.1080009@katiandgraham.com>


Hi Graham,

Thought I'd reply off-list. I've been 'hooked' by your enquiry and have been playing around, using Jane's suggestion of using
XDATE1 and XDATE2.

I've come up with the following set of Row filters to create the list of potentially Living Individuals, which I think covers all
the bases in terms of selecting all the records where the DoB is, or might be, after the target "CutOff" date, the job and wondered
how they compared with any solution you may have worked out? I've used a Parameter to set the "CutOff" Year/Date, but this could
obviously be hard-coded if required.


ADD If %INDI.BIRT.DATE:XDATE2% was later than ["CutOff"]
- adds records whose Earliest DoB (After, or Between) is after the target year (1910 in your case)

ADD If %INDI.BIRT.DATE:XDATE1% was later than ["CutOff"]
- adds records whose Latest DoB (Before or Between) is after the target year

ADD If %INDI.BIRT.DATE% was later than ["CutOff"]
- adds records that have a simple DoB after the target date

ADD If =NotExistsText(%INDI.BIRT.DATE%,"X") matches 'X'
- adds records that have either no, or an empty, Birth Event (optional, but belt-and-braces if they might still be alive)

EXCLUDE If =EstimatedBirthDate(%INDI%,LATEST,2) is less than ["CutOff"]
- removes from the Result Set any records where there is no explicit DoB set (as in the line above) but where FH is able to
calculate an Estimated DoB from the ancestors/descendants (in this case, within 2 generations)

You would obviously supplement this with an "EXCLUDE If" filter to remove any members of the Result set that have an explicit Death
date. For real belt and braces you could also "EXCLUDE If" anyone with an EstimatedDeathDate() that was (say) after the "CutOff"
(but before "Today" by definition as FH doesn't, by default, calculate future estimated dates). Anyone else left after that might
just still be alive!

I've tested this on a small database with sample data, and it seems to work (you can check what has been left out of the results by
doing a "Run and Invert Set" from the Query Menu). I'll try it on my main database at some stage.
I've attached my "Born After Date and Still Living.fhq" file if you're interested in having a play. If you think this works OK I'll
post it on the FHUG Downloads.

Quite enjoying this.

Cheers

John



-----Original Message-----
From: [mailto:] On Behalf Of Graham
Chamberlain
Sent: Monday, September 15, 2008 4:13 PM
To:
Subject: Re: [FHU] Defining Living Individuals


I searched for the string XDATE instead of XDATE1 or XDATE2. Now I also
know that the search in Help does not look for part words.

Graham

Jane Taubman wrote:
> It's documented fully in the help in the data references section. You
> can also see them in the data reference prompt on queries which is
> where I found it.
>
> 2008/9/15 Graham Chamberlain <>
>
>
>> This certainly looks like what I'm after. Is this an undocumented FH
>> feature? I can't find any reference to it in Help or the FH Manual.
>> Would you please tell me how I can use XDATE in a row filter
>> function.
>>
>>
>>

-------------------------------
To unsubscribe from the list, please send an email to with the word 'unsubscribe'
without the quotes in the subject and the body of the message

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.6.21/1671 - Release Date: 14/09/2008 07:16

This thread: