Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.filemaker > #2807

Re: Finding in a Script Using Dates with Wildcards

From Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups comp.databases.filemaker
Subject Re: Finding in a Script Using Dates with Wildcards
Date 2017-04-05 18:51 +1200
Organization Aioe.org NNTP Server
Message-ID <050420171851499161%HelpfulHarry@BusyWorking.com> (permalink)
References <1n3z5a7.12we6wpxhv9ghN%csampson@inetworld.net> <slrnoe8uct.3kh.t-usenet@ID-685.user.individual.de>

Show all headers | 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)

Back to comp.databases.filemaker | Previous | NextPrevious in thread | Next in thread | Find similar


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