aalkemist Posted June 2, 2016 Share Posted June 2, 2016 Hey All -- The solution is eluding me, so I'm hoping it is as simple as I think - I just can't get step one completed. I've created a variable to set the current date minus 60 days - Get ( CurrentDate ) -60 = $RecordsGreaterThan60 now I wish to use that to find records that are less than the variable and have a second script run on the found records Enter find mode [] Set Field [mydatefield; < $RecordsGreaterThan60] - but of course this does not work Perform Find [] I feel it's a simple thing - but alas I've got no hair left to pull out anyone, anyone....Bueller, Bueller..... Link to comment Share on other sites More sharing options...
comment Posted June 2, 2016 Share Posted June 2, 2016 33 minutes ago, aalkemist said: Set Field [mydatefield; < $RecordsGreaterThan60] - but of course this does not work Try: Set Field [ mydatefield; "<" & $RecordsGreaterThan60 ] Not sure why you need the variable. You could set the field directly to = "<" & Get ( CurrentDate ) - 60 Link to comment Share on other sites More sharing options...
[email protected] Posted June 3, 2016 Share Posted June 3, 2016 set variable $RecordsGreaterThan60 = Get ( CurrentDate ) -60 perform find <$RecordsGreaterThan60 uses two script step instead of three, which is 1/3 cooler. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2855 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