Solved

SQL:   Where SignupDate (is in March-April)

Posted on 2014-01-27
3
370 Views
Last Modified: 2014-01-27
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
Comment
Question by:arthurh88
3 Comments
 
LVL 34

Accepted Solution

by:
Brian Crowe earned 500 total points
ID: 39813595
SELECT ...
FROM myTable
WHERE MONTH(Signup_Date) IN (3, 4)
0
 
LVL 26

Expert Comment

by:Shaun Kline
ID: 39813598
Something like this?

WHERE Month(Signup_Date) IN (3, 4)
0
 

Author Closing Comment

by:arthurh88
ID: 39813617
just perfect!  thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question