Display an entered date range in a report

[rickrodod]

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?

[dbruggmann]

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 "

[rickrodod]

"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"

[Keith LaMarre]

I think you have to have at least one record on display to edit the Global.

[-Queue-]

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.

[rickrodod]

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

[dbruggmann]

Ooops! Sorry, rickrodod, for my confused script rows (and thank you, Queue, for your attention).