Declare @Now DateTime;
Declare @CurrentYear int;
Declare @EndOfSeasonThisYear DateTime;
Declare @EndOfSeasonNextYear DateTime;
Declare @Expiration DateTime;
Set @Now = GetDate();
Select @CurrentYear = Year(@Now);
Select @EndOfSeasonThisYear = DATEFROMPARTS(@CurrentYear, 6, 30); --June 30th
Select @EndOfSeasonNextYear = DATEFROMPARTS(@CurrentYear + 1, 6, 30); --June 30th
If @EndOfSeasonThisYear > @Now Begin
Set @Expiration = @EndOfSeasonThisYear;
End Else Begin
Set @Expiration = @EndOfSeasonNextYear;