1 Reply Latest reply on Apr 30, 2014 1:56 PM by philmodjunk

    Perform Find on Date Range not working



      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]

           Perform Find[]

           The resulting found set contains records whose Invoice::Date is outside the date range.