Comparing Dates in MS Access

[Suji N]

Hai Friends
I am using MS ACCESS 2000 Database
I am using the following sqlString in AWT Frame class to fetch the date from MS ACcess Database
I heard that while comparing with >= or <= we need to include # symbol between the date.<br /> I was tried by using #. But i am not able to get the results.<br /> please see the sql query and give me the solution.<br /> Thanksinadvance<br /> Yours<br /> Rajesh<br /> if(Enddate.getText().trim().equals(""))<br /> {<br /> sqlString = "select * from data_comm_err where log_date >= '" + Startdate.getText() + "'";
}
if(Startdate.getText().trim().equals(""))
{
sqlString = "select * from data_comm_err where log_date <= '" + Enddate.getText() + "'";
}

[Jamie Robertson]

The following works for me:
Non-portable MSAccess specific:

Statement ps = con.createStatement();
java.util.Date startDate = new java.util.Date();
ResultSet r  = ps.executeQuery("select * from emp where hiredate >=#"+Startdate.getText()+"#");
....

Portable --> recommended

PreparedStatement ps = con.prepareStatement("select * from data_comm_err where log_date <= ? ");
ps.setDate(1,new java.sql.Date(Startdate.getTime()));
ResultSet r  = ps.executeQuery();

Jamie
[This message has been edited by Jamie Robertson (edited November 12, 2001).]

[Suji N]

Thankyou Mr. Jamie
Your Code is Working Fine
Thankyou Very Much

Originally posted by Jamie Robertson:
[B]The following works for me:
Non-portable MSAccess specific:

Statement ps = con.createStatement();
java.util.Date startDate = new java.util.Date();
ResultSet r  = ps.executeQuery("select * from emp where hiredate >=#"+Startdate.getText()+"#");
....

Portable --> recommended

PreparedStatement ps = con.prepareStatement("select * from data_comm_err where log_date <= ? ");
ps.setDate(1,new java.sql.Date(Startdate.getTime()));
ResultSet r  = ps.executeQuery();

Jamie
[This message has been edited by Jamie Robertson (edited November 12, 2001).][/B]