Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn = DriverManager.getConnection("jdbc
dbc
ataBase","","");
Statement st = cn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
//commandline to get item from database
ResultSet rs = st.executeQuery("SELECT * FROM tblTrans WHERE R_Name ='"+tfFirst.getText()+"' AND R_Last = '"+tfLast.getText()+"'");
rs.last(); //gets last string
rs.beforeFirst(); //gets topmost value
while(rs.next()) //gets all values returned
{
vnum = rs.getString(1);
vtitle = rs.getString(4);
vquantity = rs.getString(6);
daterent = rs.getString(7);
returned = rs.getString(10);
fillunreturned(ctr); //ignore this; it's for filling up a table
ctr++;
}
System.out.println("vnum"+vnum);
System.out.println("returned"+returned);
System.out.println(""+D); //prints out the date
SimpleDateFormat sdf1 = new SimpleDateFormat("M dd yyyy", Locale.getDefault()); //date format
String dateToReturn = sdf1.format(returned); //problem area, should format the string into date
System.out.println(""+dateToReturn);
) by them during my timer recordings for bleach dub... *oh it's about to start....crosses fingers that it will work...*
ikuwento mo ke mel o ate charo.... 
just kidding!!!! 
f00l!!!!