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.....
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, Operatorn or After, Value:1/1/2008 Field:Birth Date, Operatorn 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