Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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