@SuppressWarnings("deprecation")
	public static Vector<Boarding> getDayBoarding( Date currDate ) throws SQLException{
		
		Vector<Boarding> DayBoarding = new Vector<Boarding>();
		
		String sYear = (currDate.getYear() + 1900) + "";
		String sMonth = currDate.getMonth() + "";
		String sDay = currDate.getDate() + "";

		if ( sMonth.length() < 2 )
		{
			sMonth = "0" + sMonth;
		}

		if ( sDay.length() < 2 )
		{
			sDay = "0" + sDay;
		}

		String sCurrDate = sYear + "-" + sMonth + "-" + sDay;
		
		Statement state = DBConnection.OpenConnection();
		String commandstring = "SELECT * FROM Boarding WHERE StartDate <= STR_TO_DATE('" + sCurrDate + "', '%Y-%m-%d') AND EndDate >= STR_TO_DATE('" + sCurrDate + "', '%Y-%m-%d');";
		ResultSet rs = state.executeQuery(commandstring);
		while(rs.next()){
			int PetID = rs.getInt("PetID");
			Date StartDate = new Date(rs.getDate("StartDate").getTime());
			Date EndDate = new Date(rs.getDate("EndDate").getTime());
			String KennelString = rs.getString("Kennel");
			Kennel kennel;
			if(KennelString.compareTo("cat") == 0)
				kennel = Kennel.cat;
			else if(KennelString.compareTo("smallDog") == 0)
				kennel = Kennel.smallDog;
			else 
				kennel = Kennel.largeDog;
			String Notes = rs.getString("Notes");
			//get options
			String OptionsString = rs.getString("Options");
			Vector<Options> options = parseOptionsString(OptionsString);
			
			Pet curPet = Pet.getPetByID(PetID);
			Boarding curBoard = new Boarding(StartDate, EndDate, curPet, kennel, Notes, options);
						
			DayBoarding.add(curBoard);
		}
		state.close();
		rs.close();
		return DayBoarding;
	}