<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Per OP, looking for date with format m/d/YYYY, possibly looking
for 04* or 08* or *2021 or *10*</p>
<p>In SQL a simple LIKE "%%" statement would have sufficed if you
store your date in string/variable character format (I personally
store dates in BIGINT types).</p>
<p>Back to fp - thinking that this is what the OP meant is why I
suggested using selection tables since one could use `co` "/01"
or co "01/" or co "/01/" ...</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 9/16/21 7:45 PM, Richard D. Williams
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:04CEB2D0-F4DB-47EF-A96F-D3E353721559@appgrp.net">
<pre class="moz-quote-pre" wrap="">Is it me, or does anyone else not understanding to task?
What wildcard?
Is this *clerk or *report?
Richard
Sent from my iPhone
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On Sep 16, 2021, at 8:06 AM, Jose Lerebours via Filepro-list <a class="moz-txt-link-rfc2396E" href="mailto:filepro-list@lists.celestial.com"><filepro-list@lists.celestial.com></a> wrote:
-v selectiontable is the only way I can think of - unless, you use a dynamic [selectionset] and point to it using -s (I think it is -s for reports, I rarely ever used this option).
I seem to recall someone in this list talking about dynamically creating selection tables and using them on demand, but this could be your way out
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 9/16/21 8:58 AM, Jeff Harrison via Filepro-list wrote:
What exactly are you trying to wildcard? The month? The year? You can use the index if you have a range between two dates. If you have multiple ranges then you would need to write your selection with select processing using the lookup dash.
Jeff
Sent from Yahoo Mail on Android
On Thu, Sep 16, 2021 at 8:46 AM, Richard Kreiss via Filepro-list<a class="moz-txt-link-rfc2396E" href="mailto:filepro-list@lists.celestial.com"><filepro-list@lists.celestial.com></a> wrote: Not a lookup. This is just straight index access from do’s menu.
Richard
Sent from my iPhone
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On Sep 15, 2021, at 11:47 AM, Fairlight via Filepro-list <a class="moz-txt-link-rfc2396E" href="mailto:filepro-list@lists.celestial.com"><filepro-list@lists.celestial.com></a> wrote:
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
No. Best you can do is a set of conditional lookups with static
indexes:
if: condition1
then: lookup [...] i=a
if: condition2
then: lookup [...] i-b
[etc.]
m->
On Wed, Sep 15, 2021 at 03:41:05PM +0000, Richard Kreiss via Filepro-list thus spoke:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">I can'
T remember can I use a wild card with an index.
If I can. How?
I am trying to find a date record using an index the date is field 4(10,myyy/). This means that the month and date would be 2 digits and the years 4 digits with a slash (/) separating them.
Thanks for any assistance.
Richard Kreiss
GCC Consulting
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 14426 bytes
Desc: not available
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210915/b2173782/attachment.bin"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20210915/b2173782/attachment.bin></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">--
Audio panton, cogito singularis.
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210916/6524bc05/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20210916/6524bc05/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">--
Jose Lerebours
(954) 559-7186
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210916/a7f78f47/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20210916/a7f78f47/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
</blockquote>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>
Jose Lerebours<br>
(954) 559-7186<br>
<theader></theader></div>
</body>
</html>