• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

SQL: Where SignupDate (is in March-April)

How do I formulate a WHERE clause to filter my records for
Where Signup_Date (is in march or april)

Notice:  if someone has a signup date for March 3, 2011, or April 20, 2012, it will still get pulled.  Only looking at month.
0
arthurh88
Asked:
arthurh88
1 Solution
 
Brian CroweDatabase AdministratorCommented:
SELECT ...
FROM myTable
WHERE MONTH(Signup_Date) IN (3, 4)
0
 
Shaun KlineLead Software EngineerCommented:
Something like this?

WHERE Month(Signup_Date) IN (3, 4)
0
 
arthurh88Author Commented:
just perfect!  thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now