[AccessD] Date problem in Bound Form

Yep

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: 23 November 2006 13:55
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date problem in Bound Form

...the same field name is used in both filter fields in your example?

William Hindman

----- Original Message ----- 
From: "Beach Access Software" <bchacc at san.rr.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, November 23, 2006 4:36 PM
Subject: [AccessD] Date problem in Bound Form


> Dear List:
>
>
>
> I have a bound form which has as one of its fields fldScheduledStartDate.
> On the form I allow the user to input a scheduled start date filter - a >=

> a
> scheduled start date and a <= a scheduled start date.  This works real 
> well
> in American date format - mm/dd/yyyy - but when I change regional settings
> to UK it doesn't.  Everything on the bound form appears dd/mm/yyyy.  The
> date filter appears dd/mm/yyyy.  But it doesn't filter.
>
>
>
> The filter which is set to limit records with a scheduled start date in
> November looks like this:
>
>
>
> fldPMScheduleStartDate >= #01/11/2006# AND fldPMScheduleStartDate <=
> #30/11/2006#
>
>
>
> The two date are copied out of the unbound text boxes on the form just as
> they appear.  The text boxes have their format set to Short Date.
>
>
>
> Anyone know why the filter is failing to filter?
>
>
>
> MTIA,
>
>
>
> Rocky
>
>
>
> -- 
> 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

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.14/547 - Release Date: 22/11/2006
17:41