Home > IT Answers > Business Intelligence > Selecting BDay month to match Current month
Patty
10 pts.
 Selecting BDay month to match Current month
Crystal Reports
I am trying to pull a report selecting only records with a Birthday month matching the current month, regardless of year (i.e. all May birthdays). How do I do this?

Software/Hardware used:
ASKED: May 13, 2009  5:07 PM
UPDATED: January 30, 2011  9:15 PM
RELATED QUESTIONS
Answer Wiki:
Hi, You say "SELECT" and so I assume you are using SQL. Most flavors of SQL have a function to extract the month from a date. And also a special register for CURRENT DATE. Using this MONTH function makes your query very easy... something like this ... SELECT column1, column2, ..., birthdate FROM your_table WHERE MONTH(birthdate) = MONTH(CURRENT DATE) ORDER BY ... I hope this helps.
Last Wiki Answer Submitted:  July 28, 2009  3:59 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

More specific help could be provided if you confirm that you want to do this using SQL, and you specify the database you are connecting to.

carlosdl
 63,535 pts.
 

How would you do this in crystal syntax? I’m grabbing a date with mm/dd/yyy time… Just really want to look at month and day, and use the next30days function to see what birthdays are coming up im the next 30 days.

CrystalHack
 10 pts.