Jump to content
Sign in to follow this  
Mark A Snyder

Scripted date find using ≥ and a global date

Recommended Posts

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?

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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