[AccessD] Access/SQL Dates

Heenan, Lambert Lambert.Heenan at AIG.com
Mon Sep 27 10:18:53 CDT 2004


Very probably I am wrong as I've not yet had the joy of dealing with SQL
server, but is it not the case that the date delimiting character in SQL
Server is the percentage symbol (%) not pound or hash (#)?

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen
> Sent:	Monday, September 27, 2004 8:19 AM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] Access/SQL Dates
> 
> Interesting.  The SQL backend structure can not be changed as it is
> proprietary.  Yikes.
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris
> Manning
> Sent: Monday, September 27, 2004 7:27 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [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
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list