I seem to find variating answers to this topic, so here I try again.
How do I use a variable to perform a find in a script? I want to use the field contents of the current record to search for similar records.
Background: We send a lot of people out to different countries and I want to make a script that makes an excel sheet with various data based on the country field of the current record. Hence, if the current record is going to France, I want to see everybody that we currently have in France etc. However, we have two return dates so I need to do two searches:
1. Country+ departure date <=// + arrival date >=//
2. Country+ departure date <=// + Extended arrival date >=//
Is it really true that perform find cannot handle a variable?
Hope you can help.