Newbies willbilson Posted July 23, 2021 Newbies Share Posted July 23, 2021 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 [ ] Link to comment Share on other sites More sharing options...
Ocean West Posted July 23, 2021 Share Posted July 23, 2021 The field DateRange should not have quotes but rather 6/15/2021...6/30/2021 Link to comment Share on other sites More sharing options...
Newbies willbilson Posted July 23, 2021 Author Newbies Share Posted July 23, 2021 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. Link to comment Share on other sites More sharing options...
comment Posted July 23, 2021 Share Posted July 23, 2021 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. Link to comment Share on other sites More sharing options...
Newbies willbilson Posted July 23, 2021 Author Newbies Share Posted July 23, 2021 THANK YOU!! It was the global field thing. I was not aware of that. It works now. Link to comment Share on other sites More sharing options...
comment Posted July 23, 2021 Share Posted July 23, 2021 23 minutes ago, willbilson said: It was the global field thing. As I said: a lucky guess. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 980 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now