Jump to content

Can anyone tell why this doesn't work?


This topic is 980 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

  • Newbies

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.