[AccessD] Access/SQL Dates

Have you tried <'2004-09-24'

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax 0064 4 478-7456

At 28/09/2004, you wrote:
>You are incorrect.  The single quote (') is the correct delimiting character
>to replace the pound sign (#) used by Access.  The percentage symbol (%) is
>the character to use when doing a LIKE search -- Access used an asterisk
>(*).
>
>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 Heenan, Lambert
>Sent: Monday, September 27, 2004 11:19 AM
>To: 'Access Developers discussion and problem solving'; 'Nicholson, Karen'
>Subject: RE: [AccessD] Access/SQL Dates
>
>
>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
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com