willbilson

THANK YOU!! It was the global field thing. I was not aware of that. It works now.

Yes when I use it as the text variable DateRange it doesn't have quotes. Just 6/15/2021...6/30/2021. It is only when I use a literal, ie "6/15/2021...6/30/2021" (with quotes) that it does work.

I have a simple payroll app I am (trying) building. When I try to narrow an employee's time into a date range I can't get it to work. There is already a variable field called "DateRange" - it currently is "6/15/2021...6/30/2021" Script: Go to Layout [ “TimeSheet” (tblTime) ] Button 2: “Cancel”, Commit: “No” ] Enter Find Mode [ Pause:Off ] Set Field [ tblTime::dtDate; tblTime::DateRange ] Perform Find [ ] So it doesn't perform the Find - won't proceed, saying "The provided find criteria are not valid" etc Apparently I can only populate in find mode with a fixed string criteria, not with any variable. If I change the code to Set Field [ tblTime::dtDate; "6/15/2021...6/30/2021"] It works. Sorry the code is Go to Layout [ “TimeSheet” (tblTime) ] Enter Find Mode [ Pause:Off ] Set Field [ tblTime::dtDate; tblTime::DateRange ] Perform Find [ ]