[AccessD] Report filter property

[Stuart McLachlan]

Not quite, you can customise "Regional settings" in any way you want.

In Windows 10: "Settings - Region - Change data formats"

In all recent Windows versions:  COntrol Panel - Region and use the comboxes to select 
formats.



On 12 Aug 2021 at 20:20, Susan Harkins wrote:

> That's what I was wondering -- it just to depend on your regional
> setting. 
> 
> Susan H. 
> 
> 
> Isn't that a function of the system date format in Windows?
> 
> r
> 
> On Thu, Aug 12, 2021 at 4:50 PM Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> 
> > Nope, That still depends on mm/yy/yyyy being the default short date.
> > Here's what happens on my machine
> >
> > ? "#" & cdate("1 feb 2021") & "#"
> > #1/02/2021#
> >
> > {quote]
> > You must use English (United States) date formats in SQL statements
> > (SQL string/statement: An expression that defines an SQL command,
> > such as SELECT, UPDATE, or DELETE, and includes clauses such as
> > WHERE and ORDER BY."
> >
> >
> > On 12 Aug 2021 at 16:09, Rocky Smolin wrote:
> >
> > > Well then you gotta use CDATE to get it in that format.
> > >
> > > r
> > >
> > > On Thu, Aug 12, 2021 at 3:58 PM Stuart McLachlan 
> > > <stuart at lexacorp.com.pg> wrote:
> > >
> > > > #'s work OK if dates are always in mm/dd/yyyy. If your users may
> > > > #
> > > > use different date formats, it can cause big problems.
> > > >
> > > >
> > > > On 12 Aug 2021 at 7:50, Rocky Smolin wrote:
> > > >
> > > > > I always used # on dates in any SQL statement.Habit.  Why try
> > > > > without, possibly generate an error and then have to correct
> > > > > it? Delimiting a date with the #, AFAIK, will not cause a
> > > > > problem.
> > > > >
> > > > > r
> > > > >
> > > > > On Thu, Aug 12, 2021 at 5:37 AM Bill Benson 
> > > > > <bensonforums at gmail.com> wrote:
> > > > >
> > > > > > Did that sample leave out bookending dates as
> > > > > >      & "#" & Ctl.itemdata(varitem) & "#"
> > > > > >
> > > > > > Or have I been adding them unnecessarily for my entire
> > > > > > career?? :-(
> > > > > >
> > > > > > On Wed, Aug 11, 2021 at 9:49 AM Martin
> > > > > > <martinreid at gmail.com> wrote:
> > > > > >
> > > > > > > http://www.baldyweb.com/multiselect.htm
> > > > > > >
> > > > > > > Martin
> > > > > > >
> > > > > > > On Wed, 11 Aug 2021, 14:31 Arthur Fuller, 
> > > > > > > <fuller.artful at gmail.com>
> > > > > > wrote:
> > > > > > >
> > > > > > > > I want to pass an In() clause to a report. Can I use the
> > > > > > > > filter
> > > > > > property
> > > > > > > to
> > > > > > > > do this?  The port was originally  written to accept 
> > > > > > > > one parameter. I
> > > > > > > want
> > > > > > > > to remove  and use the In() instead What  is the syntax?
> > > > > > > > I have a multi-select  listbox that builds on a
> > > > > > > dialog
> > > > > > > > that builds the In() clause for me.
> > > > > > > > --
> > > >
> > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>