melliott 0 Report post Posted July 5, 2009 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? Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 5, 2009 (edited) 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 July 5, 2009 by Jim Byram Share this post Link to post Share on other sites
melliott 0 Report post Posted July 5, 2009 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
melliott 0 Report post Posted July 5, 2009 Jim, I'm getting nothing on the report. Is there a way that I can show you, with a print screen, what I'm doing? Maureen Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 5, 2009 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
melliott 0 Report post Posted July 5, 2009 Tag Type... Label = Equals BIRTH AND Date - Day = Equals 03 AND Date - Month = Equals DEC END Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 5, 2009 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
melliott 0 Report post Posted July 5, 2009 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
Jim Byram 0 Report post Posted July 5, 2009 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
melliott 0 Report post Posted July 5, 2009 Thanks, Jim! That did the trick. I spelled out the month and used just the day = July 5. Maureen Share this post Link to post Share on other sites
melliott 0 Report post Posted July 5, 2009 Sorry, Jim, about not being clear. I truly thank you for your patience and your solution! Maureen Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 5, 2009 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