Can anyone tell why this doesn't work?

[willbilson]

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 [  ]

[Ocean West]

The field DateRange should not have quotes but rather 6/15/2021...6/30/2021

[willbilson]

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. 

 

[comment]

Without providing a way to reproduce the problem, the best you can hope for is a lucky guess.

I don't like to guess - but my first suspect would be the tblTime::DateRange field. You called it "a variable field". There is no such thing. And you didn't explain how this field gets populated. I suspect that the field does not contain what you think it does. Or perhaps it's not a global field - in which case it does not contain anything when you are in Find mode.

 

[willbilson]

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

[comment]

23 minutes ago, willbilson said:

It was the global field thing.

As I said: a lucky guess.