<div dir="ltr"><div>that's what I thought but it's only picking records where the actual 1st pmt field is @td</div><div>There are 3 records where the 2nd pmt date is today but it's not selecting them, but it's showing them when I browse using that index?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 22, 2015 at 4:48 PM, Jose Lerebours via Filepro-list <span dir="ltr"><<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">a1)    eq    @td<br>
<br>
then process record just as you normally would ...<div><div class="h5"><br>
<br>
<br>
<br>
On 12/22/2015 04:40 PM, scooter6--- via Filepro-list wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
I have created a file that can have up to 12 credit card transactions dated<br>
today or in the future...<br>
<br>
So each morning I want to send the current dated ones to be processed but<br>
think I'm having a brain cramp on this...<br>
<br>
I have 12 fields that are date fields (each shows as a1) Date of 1st Pmt<br>
a1) Date of 2nd Pmt, etc...then each has it's corresponding amount....<br>
<br>
How would I select records dated just today and grab the corresponding<br>
amount for that date?<br>
<br>
I have the index built and can search by that day, but do I need to 'step'<br>
though each of the 12 dates and if it matches today grab the amount in the<br>
amount field for that day?<br>
<br>
I tried this and am exporting these records but it only exports the last<br>
record it finds with today's date??<br>
<br>
Scott<br>
PDM<br></div></div>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20151222/a508c86c/attachment.html" target="_blank" rel="noreferrer">http://mailman.celestial.com/pipermail/filepro-list/attachments/20151222/a508c86c/attachment.html</a>><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div><br></div>