Between Dates

Brad Weiland · #1 August 29th, 2008, 03:32 AM

Hi,

I'm new to SQL and I have the following quesiton.

I have table of data as follows:

Date
31-01-2007
12-31-2007
31-01-2008
31-12-2008

If a want to create an if statement that says if date falls between 31-01-2007 and 12-31-2007 put Year 1, if date falls between 31-01-2008 and 31-12-2008 put Year 2, etc.

Do I use the following formula:

CASE When Date >=31-01-2007 AND <=12-31-2007 THEN "Year 1,

Atli · #2 August 30th, 2008, 07:35 PM

Hi.

You could use the BETWEEN ... AND syntax. Like:

Expand|Select|Wrap|Line Numbers

SELECT 2 BETWEEN 1 AND 3;

Replacing the numbers with dates.

Brad Weiland · #3 September 4th, 2008, 03:25 AM

I figured it out the answer to my question

Expand|Select|Wrap|Line Numbers

 
CASE WHEN Invoice Date BETWEEN '01-APR-2005' AND '31-MAR-2006' THEN '05-06' ELSE CASE WHEN Invoice Date BETWEEN '01-APR-2006' AND '31-MAR-2007' THEN '06-07' ELSE '0' END END

Between Dates

Popular Articles

What is Bytes?