Perform Find on Date Range not working
I have tried this technique that I got from posts on this forum. I have a table "Company" related to table "Invoice". There are two global search fields in Company called g_dateOne and g_dateTwo where the user can select a date range. I then want to perform find on the field Invoice::Date.
My script is:
Enter Find Mode
Set Field[ Invoice::Date; Company::g_dateOne & "..." & Company::g_dateTwo]
The resulting found set contains records whose Invoice::Date is outside the date range.