Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Display an entered date range in a report

Featured Replies

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?

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 "

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

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

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.

  • 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

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

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.