multiple field index

[Jose Lerebours]

a1)    eq    @td

then process record just as you normally would ...



On 12/22/2015 04:40 PM, scooter6--- via Filepro-list wrote:
> I have created a file that can have up to 12 credit card transactions dated
> today or in the future...
>
> So each morning I want to send the current dated ones to be processed but
> think I'm having a brain cramp on this...
>
> I have 12 fields that are date fields (each shows as a1) Date of 1st Pmt
> a1) Date of 2nd Pmt, etc...then each has it's corresponding amount....
>
> How would I select records dated just today and grab the corresponding
> amount for that date?
>
> I have the index built and can search by that day, but do I need to 'step'
> though each of the 12 dates and if it matches today grab the amount in the
> amount field for that day?
>
> I tried this and am exporting these records but it only exports the last
> record it finds with today's date??
>
> Scott
> PDM
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20151222/a508c86c/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list