* Date query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
kcuypers
Platinum
Posts: 45
Joined: 20 Nov 2017 03:00
Family Historian: V7
Location: Belgium

Date query

Post by kcuypers » 23 Nov 2021 19:55

Hello,
I want to make a query
The first part is :
Columns:
Columns.png
Columns.png (7.24 KiB) Viewed 145 times
Rows
Rows.png
Rows.png (5.26 KiB) Viewed 145 times
Result
Result Set.png
Result Set.png (132.72 KiB) Viewed 145 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: 22765
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Date query

Post by tatewise » 23 Nov 2021 21:33

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 » 24 Nov 2021 04:15

Tatewise,

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

Greetings

Koen

Post Reply