Jump to content

Scripted date find using ≥ and a global date


This topic is 5563 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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
Link to comment
Share on other sites

This topic is 5563 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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