Groups > comp.databases.filemaker > #2807

Re: Finding in a Script Using Dates with Wildcards

Path	csiph.com!aioe.org!.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Finding in a Script Using Dates with Wildcards
Date	Wed, 05 Apr 2017 18:51:49 +1200
Organization	Aioe.org NNTP Server
Lines	20
Message-ID	<050420171851499161%HelpfulHarry@BusyWorking.com> (permalink)
References	<1n3z5a7.12we6wpxhv9ghN%csampson@inetworld.net> <slrnoe8uct.3kh.t-usenet@ID-685.user.individual.de>
NNTP-Posting-Host	Pzl171PSpYGm1czmN9V2+w.user.gioia.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Thoth/1.8.4 (Carbon/OS X)
X-Notice	Filtered by postfilter v. 0.8.2
X-Face	vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref	csiph.com comp.databases.filemaker:2807

Show key headers only | View raw

In article <slrnoe8uct.3kh.t-usenet@ID-685.user.individual.de>, Martin
‘§rautmann <t-usenet@gmx.net> wrote:
> On Tue, 4 Apr 2017 20:51:03 -0700, Charles H. Sampson wrote:
> >
> > How do you execute a find in a script using a date such as 3/*/2017?
> > Whenever I try it, I get a message that "3/*/2017" is not a date.
> >
> > As usual, I'm still using FileMaker Pro 8.0v3 on a G5 running 10.5.8.
> 
> Try 3/1/2017..3/31/2017
> Martin

That would be the best way (although I thought it was three dots
between the two dates). The Find Mode wildcards aren't really designed
for anything except text.

You could try using the function GetAsDate("3/*/2017"), but I doubt
that will work either.

Helpful Harry  :o)

Thread

Finding in a Script Using Dates with Wildcards csampson@inetworld.net (Charles H. Sampson) - 2017-04-04 20:51 -0700
  Re: Finding in a Script Using Dates with Wildcards Martin Τrautmann <t-usenet@gmx.net> - 2017-04-05 04:59 +0000
    Re: Finding in a Script Using Dates with Wildcards Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-04-05 18:51 +1200
  Re: Finding in a Script Using Dates with Wildcards Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2017-04-05 11:08 -0700
  Re: Finding in a Script Using Dates with Wildcards csampson@inetworld.net (Charles H. Sampson) - 2017-04-10 13:57 -0700
    Re: Finding in a Script Using Dates with Wildcards ursus <ursus.kirk@gmail.com> - 2017-04-10 23:41 +0200
    Re: Finding in a Script Using Dates with Wildcards Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2017-04-10 14:58 -0700
      Re: Finding in a Script Using Dates with Wildcards Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-04-11 13:51 +1200
        Re: Finding in a Script Using Dates with Wildcards Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2017-04-10 19:40 -0700

csiph-web