[AccessD] Un-American Date Filter

How does everyone connect to their data on their SQL server? 

I have never done any other method than by passing parameters and calling
the appropriate SP. Does everyone else actually just send sql strings?

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, March 31, 2011 3:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Un-American Date Filter

That is, unless the backend may be SQL Server, in which case, the
delimiter is a single quote.  We used to run into that issue in .Net,
so we built a function to return the date string formatted with the
correct delimiter depending on which database was in use.  Easy enough
to create a function to format any date to US format as well.

Charlotte Foust

On Thu, Mar 31, 2011 at 2:58 PM, Shamil Salakhetdinov
<shamil at smsconsulting.spb.ru> wrote:
> Hi Rocky --

> Of course date string used in SQL expression in American format should be
> enclosed in a pair of '#' symbols - #04/01/2011# ....
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com