*Partial Dates Fact Query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
DataMad
Newbie
Posts: 4
Joined: 06 Oct 2013 21:38
Family Historian: V5

Partial Dates Fact Query

Postby DataMad » 12 Aug 2018 19:19

How would I do a fact query to find facts with partial dates, for example only the year entered?

User avatar
BillH
Megastar
Posts: 1321
Joined: 31 May 2010 03:40
Family Historian: V6.2
Location: Washington State, USA

Re: Partial Dates Fact Query

Postby BillH » 12 Aug 2018 20:19

If all you have is the year, you could use Add if %FACT.DATE:COMPACT% was on ["DATE"]. Then check that you want to use a parameter and it will prompt for the value.

This will also work for a full date, but not if you just have a day and month or a month and year.
Bill Henshaw

User avatar
tatewise
Megastar
Posts: 14833
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Partial Dates Fact Query

Postby tatewise » 12 Aug 2018 21:28

On the Rows tab use a filter such as:
Exclude unless =Day(%FACT.DATE%) is null
That will include every Fact whose Date has no Day of Month defined.
i.e. a partial date with just a Month & Year or just a Year.

Exclude unless =Month(%FACT.DATE%) is null will include only those with just a Year.

However, that will include any Fact without a Date at all, so supplement with:
Exclude if %FACT.DATE% is null

BTW: Using the Exclude ... filters means their order is unimportant, whereas with Add if ... the order matters..
Mike Tate ~ researching the Tate and Scott family history.

DataMad
Newbie
Posts: 4
Joined: 06 Oct 2013 21:38
Family Historian: V5

Re: Partial Dates Fact Query

Postby DataMad » 13 Aug 2018 10:47

Thanks to Mike Tate and Bill Henshaw.


Return to “General Usage”

Who is online

Users browsing this forum: Bing [Bot] and 16 guests