AnsweredAssumed Answered

Perform Find on Date Range not working

Question asked by AdamQuintero on Apr 30, 2014
Latest reply on Apr 30, 2014 by philmodjunk


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.