[AccessD] Report filter property

[Susan Harkins]

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