Birthday List

Jun 26, 2006 4 Replies

I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional information) I collect customers' dogs' names and birthdays (up to 4 dogs per customer). Each month I would like to mail customers birthday cards/promos based on their pet's birthday.



My problem is that my report criteria is quite lengthy. I have to set each "Birthday" field with a range "06/01/1996 to 06/30/1996" "06/01/1997 to



06/30/1997" etc. Then I have to do the same multiple entries for 3 more "Birthday" fields.

Is there a way to just use a Filter of only the Month Range without a specific year? That way I could simply generate a list of all dogs in month of June without regard of 1998,1999..etc. Any help would be great. Thanks


What report are you starting from?

You can customize the report to include a filterable column that is based on the Month DATEPART (DATEPART is a SQL function).

Glenn Adams Tiber Creek C> I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional

Thanks Glenn for your response. I am using the standard labels list in Crystal reports. How exactly would you customize that report.

Also, do you have any suggestions regarding a primer for SQL (books website, etc.)

Thanks again.

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Sorry, I don't do Crystal. You can edit the reports, but I believe that you need a copy of the Crystal software (Version 8) to do it.

SQL Server Books Online at msdn.microsoft.com is a great resource for SQL Server...

Glenn Adams Tiber Creek C> Thanks Glenn for your response. I am using the standard labels list in

We can do this custom report for you. Please contact us if you are interested.

Jamieson Gill

formatting link

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP03.phx.gbl...

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required