Yes, that is technically tricky because the Query is focused on Facts rather than Individuals.
The starting point is to use the
=FactOwner(%FACT%,1,MALES_FIRST) column expression.
That gives you the Individual record whose Birth Date you want to check.
The Expression:
=Field( FactOwner(%FACT%,1,MALES_FIRST), 'INDI.BIRT.DATE' ) references that DoB.
To extract the Year use Expression:
=Year( Field( FactOwner(%FACT%,1,MALES_FIRST), 'INDI.BIRT.DATE' ) )
e.g.
- image.png (25.67 KiB) Viewed 213 times
Duplicate that for
is greater than 1890 and repeat both for
FactOwner(%FACT%,2,MALES_FIRST)
Is there always a Birth Date recorded or might there only be a Baptism Date?
It might be better to involve the EstimatedBirthDate() function.
e.g.
=Year( EstimatedBirthDate( FactOwner(%FACT%,2,MALES_FIRST), MID, 2) )
That will use the DoB if it exists or the Baptism/Christening date or a date estimated from close relative's dates.