Hi Jeff, the correct syntax in access itself would be:
>#9/30/1999# the writing of the data (mm.dd or dd.mm or mm/dd) belongs to the system variables set on the system acess is installed on. But in every case you have to use the # sign. hth Li > Date: Wed, 05 Mar 2003 07:24:04 -0500 > From: Jeff Thies <[EMAIL PROTECTED]> > Organization: The Limit Publications > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: date time in Access > I'm having trouble with date time in Access with DBI/ODBC > > I'm trying to do this: > > SELECT * FROM some_table WHERE date_time_field > 11/30/99 > > That's giving me all dates, where: > > SELECT * FROM some_table WHERE date_time_field < 11/30/99 > > Is giving me none. > > I must have done something completely wrong! > It really is a date time field and looks like this: 1998-06-25 00:00:00 > > Jeff > >
