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.

Scripted date find using ≥ and a global date

  •
Mark A Snyder
in Finding & Searching

Featured Replies

  • Newbies

In a script, I'm setting a global date field with a date value entered in the Show Dialog script step. I then want continue the script to find all records with a date that is equal to or greater than the global date.

I first thought I could simply use the enter find mode script step, set the date field to ≥ global date, and then perform find. But, FileMaker does not allow the ≥ character. I can get around this using copy and paste but that is sloppy.

What is the best way to script this?

Hi Mark, welcome to the greatest FileMaker forum in the universe!!

The :great: must be treated as text so it would be:

Enter Find Mode [ uncheck pause ]

Set Field [ yourDateField ; ":great:" & global date ]

Perform Find [ ]

Capture the global date from the User (within the Custom Dialog) before entering Find Mode.

LaRetta :wink2:

Edited by Guest

  • Author
  • Newbies

Perfect!

Thanks

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

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.