Jump to content

Recommended Posts

Is it possible for me to run a report of everyone in my database that has the same birthday, just month and year? For example everyone that has a birthday on July 5? :rolleyes:

Share this post


Link to post
Share on other sites

List of Events

 

Filter...

Tag Type... Label = Birth AND

Date - Year = someyear AND

Date - Month = somemonth END

 

If you want to be prompted for the month and year when you run the report...

Tag Type... Label = Birth AND

Date - Year = [?] AND

Date - Month = [?] END

 

You should also look at John Cardinal's utility 'On This Day'.

http://www.johncardinal.com/otd/

Edited by Jim Byram

Share this post


Link to post
Share on other sites
List of Events

 

Filter...

Tag Type... Label = Birth AND

Date - Month = somemonth AND

Date - Year = someyear END

 

If you want to be prompted for the month and year when you run the report...

Tag Type... Label = Birth AND

Date - Month = [?] AND

Date - Year = [?] END

 

You should also look at John Cardinal's utility 'On This Day'.

http://www.johncardinal.com/otd/

Share this post


Link to post
Share on other sites

I revised the filters above but they work either way. Tested the filter and found no problems.

 

What's your filter?

Share this post


Link to post
Share on other sites

Try '3' and 'DECEMBER'. And you know that you have a Birth event in the data set occurring on Dec 3?

 

I have a Birth event on 9 Sep 1851 and '9' and 'SEPTEMBER' worked.

 

btw... On This Day does this for all dates and everyone.

Share this post


Link to post
Share on other sites

Jim,

I can get the Birth and the date month, but, I can't get it to include the birth day. And, the output column will only sort by a full date: 03 Dec 1930 and it's order is by year. I want to be able to pull out just the day and the month. Ex: 03 Dec

Maureen

Share this post


Link to post
Share on other sites

You are not being consistent in your questions so I have no idea what you are asking. Are we now talking about output columns in the report?

 

You can add Date - Day and Date -Month columns. But the report filter results in all output having the same day and month so it makes no sense to sort by those columns.

 

You need to state your questions very clearly so it's possible to respond.

Share this post


Link to post
Share on other sites

You could also create a report of all Birth tags and sort the report by Date - Month and then Date - Day.

 

Use the filter...

Tag Type... Label = BIRTH END

 

Delete the Date output column.

Add an output column for Date - Month and set the sort on that column to '1'.

Add an output column for Date - Day and set the sort on that column to '2'.

 

Now you have a report of all birthdays sorted by month and day.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×