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

Groups > comp.databases.filemaker > #2810

Re: Finding in a Script Using Dates with Wildcards

Show all headers | View raw

Op 10-4-2017 om 22:57 schreef Charles H. Sampson:
> Charles H. Sampson <csampson@inetworld.net> 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.
>> ,,,
>
> I got useful advice from three of the usual suspects. Thanks to all.
> However, it's clear that my question was much to imprecise. To try to
> clarify, here's an example of what I've been trying:
>
> The month that I want to use is input using a custom dialog. It's
> therefore in a global field, named DISummaryMonth. I calculate the year
> based on the assumption that the most recent of the specified months is
> meant; this value is in $SummaryYear. The following code doesn't work:
>
>    Go to Layout ("xyz")
>    Enter Find Mode []
>    Set Field [xyz::Date; Date (DISummaryMonth, "*", $SummaryYear]
>    Perform Find []
>
> The result is the error message "No records match this set of find
> requests." This isn't surprising when I display xyz::Date before
> performing the find; it is "?" and that's what is displayed in the Date
> field of layout xyz. The value xyz::Date: [?]  has also been filled into
> the specification of the Perform Find command.
>
> I hope this is clearer, I'm willing to continue to clarify as long as
> you are willing to put up with me.
>
> Charlie
>


Since you are performing a find on a Date type, this is not going to 
accept the * as wildcard. You have to rethink and look into finding a 
date RANGE. Like find every date starting from the 1st of month x 
through to the last of month x. Now I could explain (or try) how to do 
that. But somebody much smarter has done it before me.

http://help.filemaker.com/app/answers/detail/a_id/5912/~/how-to-write-a-script-that-finds-a-range-of-dates-in-filemaker-pro

-- 
Keep well, Ursus

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

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