Skip 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.

Scripting current date + 6 days?

Featured Replies

We are currently converting a large number of databases from v6 to v8, and I've come across my first real problem so far. A calendar db we have has some scripted buttons that show records for the current date + up to one month ahead. I noticed that converting to v8 updated the syntax of the scripts to be v8 compliant, but they no longer work. I didn't write the original scripts, but have managed to get only the one that selects the current date to work. Anything that appends a set range to the current date just pops up a dialogue box complaining about invalid find criteria.

The important lines of the converted script are like so:

Enter Find Mode []

Insert Calculated Result [select; calendar::date; "//..."&GetAsText(Get(CurrentDate)+6)]

Insert Calculated Result [select; calendar::Level; "1"]

Perform Find []

I've tried a few variations on this theme, but no go. Anyone know how to achieve this in FM 8?

Cheers,

Kevin

I'd try it this way:

Enter Find Mode []

Set Field [ calendar::date; get(currentdate) & "..." & Get(CurrentDate)+6]

Set Field [ calendar::Level; 1]

Perform Find []

  • Author

Thanks. I actually tried something similar to that, but still using a calculated result. Needless to say, it didn't work, but I'll give your variation a go and report back.

Cheers,

Kevin

  • Author

Just a quick report back - works like a charm! Must remember from now on: Set Field, Set Field, Set Field ...

Cheers and thanks,

Kevin

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.