Thank you both!

Sean, I should have been more clear, I have a date field that I am calling myDate and want to check against the field (not using current date/GetDate()). I always appreciate you help!

Lowell, this works great!

The next step I would be looking to do is be able to change the then and else values based on the date field year.

If the date field year is 2014 and greater it wouldnt make sense to have the THEN be 2013 and ELSE be 2013

For example:

SELECT

OtherColumns,

CASE

WHEN myDate > '6/30/2015'

THEN '2013'

ELSE '2012'

END as getSeason

FROM myTable

Can I make the THEN ELSE values vary based on the myDate field's year?