June 21, 200421 yr Hi Guys, I have a script that filters for a range of dates by the following: go to field[datefield] Enter Find Mode(pause) Perform FInd I enter a date range using an entry like: 01/01/2004..01/31/2004 I would like to display the entered date range in the header of a report. Can someone steer me in the right direction?
June 21, 200421 yr Start your script in Browse mode and enter your date range into to a global field g_dateRange: Enter Browse Mode go to field [select/Perform, "g_dateRange"] Pause/Resume Script [] Insert Calculated Result [select; "datefield"; "g_dateRange"] Enter Find Mode [] Perform FInd (I'm not sure, if "Insert calculated result" exists in FM5; otherwise you would have to use copy and paste, I think.) Afterwards you can simply display the global field in the report header. Or use a calculation field which extracts the date range more properly (ie. " until " instead of the "
June 22, 200421 yr Author "insert calculated result" does exist in FM5 Thanks for the tip! However, now when I run the script I'm getting the message: "this field is not modifiable"
June 22, 200421 yr Transpose the Insert Calculated Result and Enter Find Mode steps or you're changing the data in Browse mode and not entering criteria for a find.
June 23, 200421 yr Author Y E S ! ! ! Transposing "insert calculated result" and "enter find mode" was the answer! That's it.! Some say don't sweat the small stuff. But I can sure get lost in it. THANK YOU
June 23, 200421 yr Ooops! Sorry, rickrodod, for my confused script rows (and thank you, Queue, for your attention).
Create an account or sign in to comment