* Date query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
kcuypers
Platinum
Posts: 45
Joined: 20 Nov 2017 03:00
Family Historian: V7
Location: Belgium

Date query

Post by kcuypers »

Hello,
I want to make a query
The first part is :
Columns:
Columns.png
Columns.png (7.24 KiB) Viewed 771 times
Rows
Rows.png
Rows.png (5.26 KiB) Viewed 771 times
Result
Result Set.png
Result Set.png (132.72 KiB) Viewed 771 times
and this is OK.

Now i want to add in this query from a date to a date, for instance (1-1-1820) to (1-1-1880).
How can i do this?

Greetings
Koen
User avatar
tatewise
Megastar
Posts: 28405
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Date query

Post by tatewise »

Hi Koen,
Firstly, your existing Rows tab filters seem a bit unusual to me.
Add unless %INDI.BIRT.PLAC>% is null will add everyone whose Birth event has a Place regardless of Date.
Add unless %INDI.BIRT.DATE% is null will add everyone whose Birth event has a Date regardless of Place.
There will be many rows with both a Birth Place and a Birth Date.
But you will have some rows with a Birth Place but no Birth Date and others with a Birth Date but no Birth Place.
i.e. The filter is saying add everyone who has either a Birth Place or a Birth Date.
Is that what you wanted?

My guess is that you wanted everyone with both a Birth Place and a Birth Date and that needs:
Exclude if %INDI.BIRT.PLAC>% is null
Exclude if %INDI.BIRT.DATE% is null
I apologise if my guess is mistaken.

To further constrain the Date, use the was earlier than and was later than Operators and add these two Rows:
Exclude if %INDI.BIRT.DATE% was earlier than 1 Jan 1820
Exclude if %INDI.BIRT.DATE% was later than 1 Jan 1880
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
kcuypers
Platinum
Posts: 45
Joined: 20 Nov 2017 03:00
Family Historian: V7
Location: Belgium

Re: Date query

Post by kcuypers »

Tatewise,

I change it a little bit with the parameter option and it's great!!.
Rows2.png
Rows2.png (4.79 KiB) Viewed 719 times
Thanks for helping me.

Greetings

Koen
Post Reply