This content has been marked as final. Show 3 replies
I recommend find 'by relationship'. Create a new table occurance based on invoice table and connect it with the two conditions:
- start date = invoice date
- end date >= invoice date
now you can show the matching invoices in a portal or in a list with the script step GoToRelatedRecord.
I think that it better to explicity say that the "start date" and "end date" must be global fields.
This is helpful, thanks - Jens