month comparision in asp.net

Question

Hi,

 

 I want to save a variable in sql table in place of date.

Example:

 

if date is in between January to June and my date is: 8 May 2014 then var = value1

 

if date is in between July to December and my date is 20 September 2014 then var = value2

 

if question is not clear plz let me now I will more explain..

 

please help.