D Space Posted August 3, 2006 Posted August 3, 2006 FM8 If I'm in find mode I can do a find request in a timestamp field by entering, for example, >01/01/2006 08:00 AM and it will find the appropriate records. I want to do the same thing in a script where I have set a script variable = to a timestamp value. I enter find mode set field (timestampfield; ">$$scriptvariable") perform find It doesn't find the appropriate records and if I leave out the perform find, I can see the timestampfield is not filled in. I assume that is because ">$$scriptvariable" resolves to text and not timestamp. If that's the case, how can I enter this constraint in that field via the script. Everything I try seems to result in an error in the script editor. Thanks for any help.
sbg2 Posted August 3, 2006 Posted August 3, 2006 Try: set field (timestampfield; ">" & $$scriptvariable)
Recommended Posts
This topic is 6689 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