[AccessD] Un-American Date Filter

That's how I do it

Sent from my Droid phone.
On Mar 31, 2011 9:46 PM, "Jim Lawrence" <accessd at shaw.ca> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com