Selecting BDay month to match Current month

Patty

10 pts.

Tags:

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?

Asked: May 13, 2009 5:07 PM Last updated: January 30, 2011 9:15 PM

Answer Wiki

Last updated: July 28, 2009 3:59 PM GMT

Meandyou5,220 pts.
History
Contributors
- Ordered by most recent
- Meandyou5,220 pts.

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2 Replies

carlosdl Jul 28, 2009 4:21 PM GMT

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.

84,495 pointsBadges:

report
CrystalHack Jan 30, 2011 9:15 PM GMT

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.

10 pointsBadges:

report