[AccessD] Access/SQL Dates

I ran into this problem when I used smalldatetime in the table as the data
type instead of datetime.  To be honest, I was in a hurry and didn't have
time to figure out why it was happening.  I just changed from smalldatetime
to datetime and the problem went away.  I've never used smalldatetime since
then.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen
Sent: Monday, September 27, 2004 6:33 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access/SQL Dates


I have an Access front-end and am querying an SQL backend.  When putting in
a select statement in the query, all is fine if I specify a date of say,
less than today or <date()... However, if I try to specify a particular
date, I get an sql overflow error.  The syntaxes I have tried
include: <#9/27/2004#  <'9/27/2004' <'20040927'.  Any clues?  Thanks.

Karen Nicholson
National Laboratory
Xerox Global Services


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com