ukmgranger Posted November 12, 2007 Share Posted November 12, 2007 (edited) Hi all, Please be gentle I am a newb! I need to generate a report that only shows me clients that have a job booked in within the next seven days. How do I set up a script to do this? Thanks in advance!! Edited November 12, 2007 by Guest Link to comment Share on other sites More sharing options...
aldipalo Posted November 12, 2007 Share Posted November 12, 2007 (edited) Enter find mode() /* pause unchecked Set Field(datefield; get(currentdate)& "..."& Get (Currentdate)+ 7) Or set up 2 new date fields: Startdate enddate /* Of course you need to have these fields on the layout and need to input the dates prior to running the script. You could make them a calc field. StartDate = Get(Currentdate); enddate=get(currentdate + 7) */ Set Field(datefield;startdate &"..." & enddate) Perform Find() Edited November 12, 2007 by Guest Link to comment Share on other sites More sharing options...
Newbies Haifisch Posted December 10, 2007 Newbies Share Posted December 10, 2007 Hi I'm jumping on the train right here, as I have a similar question: I want to see all entries which are older than 180 days. I tried the following script, but without success: Action: Find records find criteria: Date﹝≤(//-180)﹞ No success, all of the entries appear (even these younger than 180 days. Is it possible like this? Thanks in advance for any comments. Harry Link to comment Share on other sites More sharing options...
The Shadow Posted December 11, 2007 Share Posted December 11, 2007 The "//" unfortunately doesn't work like that. You'll need a script more like aldipalo shows, with something like: Set Field( dateField; "<=" & Get(CurrentDate) - 180 ) as your dynamic find criteria. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6123 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