Out of interest another way to do this without using functions on a Fact Query is to simply add a filters on the DAY and MONTH_NUMBER qualifiers for the Date.  
e.g
Add if %FACT.DATE:DAY% = 25
Exclude Unless %FACT.DATE:MONTH_NUMBER% = 12
and of course you could tick the parameter option to get them to prompt you for the Day and Month you want.

Virus-free. www.avg.com

Mike

Thanks.  I've looked at the examples in the link you sent and I've got something working- I just need to play around to get the columns exactly how I want them  (after I get to grips with the function syntax which the examples will help with).

I think it would be nice if it was possible to select the functions for columns in a similar way that one can select Facts / events in queries.  I'm still on FH6 - does FH7 improve this sort of thing ??

Brian

Yes, there are many ways that and other options can be exercised.

Checkout the FH standard Fact Queries like All Facts.

See the Knowledge Base for loads of advice…

https://fhug.org.uk/kb/kb-article/an-overview-of-queries/

Look under Sorting a Fact Query on Owner Surname

Also, the Downloads for Fact Queries has many examples.

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 12:20
To: family-historian@groups.io
Subject: Re: [family-historian] Finding Specific Dates

 

Mike

Once I realised I had to change the Query type to a "Fact" query, I managed to get a list of events with that date so thanks for that.  I've also got it working with a Parameter box so I can easily check any data I like.

However, I cannot seem to see a way of displaying the relevant individual in a Column that the event "happened" to.  If I click on one of the results it takes me to the relevant Individual's Property box but none of the Query "Column" fields seem to offer a way of identifying the person in the result set.  Can this be done ??

Many thanks

Brian

On 16/12/2020 10:28, Mike Tate wrote:

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian

 

Virus-free. www.avg.com

 

Mike

Once I realised I had to change the Query type to a "Fact" query, I managed to get a list of events with that date so thanks for that.  I've also got it working with a Parameter box so I can easily check any data I like.

However, I cannot seem to see a way of displaying the relevant individual in a Column that the event "happened" to.  If I click on one of the results it takes me to the relevant Individual's Property box but none of the Query "Column" fields seem to offer a way of identifying the person in the result set.  Can this be done ??

Many thanks

Brian

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian

 

Virus-free. www.avg.com

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian

Virus-free. www.avg.com

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian