Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lookup of Birthdays

Copper Contributor
Posts: 22
Country: Canada

Lookup of Birthdays

Does anyone know how I can do a report of contacts that have a birthday in May for example.  I have created a Date Field and populated it with the contacts Date of Birth.....but when I try and do a report it calculates based on the year....how can I get the report to just ignore the year and only analyze the day and month?  Any help would be appreciated....Thanks.....Smiley Happy
Employee
Posts: 1
Country: USA

Re: Lookup of Birthdays

One way to do it would be to use the existing Birthday field on the Contact Detail view,
create a lookup then run a report over that lookup.
 
Here's an example:
 
1.  Use Advanced Query to create a lookup.
    Lookup > Advanced > Adv Query
    Field:Birth Date, OperatorSmiley Surprisedn or After, Value:1/1/2008
    Field:Birth Date, OperatorSmiley Surprisedn or Before, Value:1/31/2008
    (save the query as "jan_birthdays")
 
2.  Run the Contact Report for the lookup.
    Reports > Contact Reports
    Create report for: Current Lookup
 
Hope this helps !
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Lookup of Birthdays

Tuned Listener
Posts: 58
Country: USA

Re: Lookup of Birthdays

Mike,

 

Is there a way to look up a contact's spouse date of birth if I have that in a separate field?

 

Thanks

Rusty

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Lookup of Birthdays

Tuned Listener
Posts: 58
Country: USA

Re: Lookup of Birthdays

Mike,

 

I figured it out after playing with it, but thanks for the quick response.

 

Rusty