Variables inside Constrain Found Set not being processed correctly

[Rich S]

This one's driving me crazy because when I manually enter the date range in the appropriate field during a Find the data comes up fine. However, when when the script calls the variables--which have the same dates I used when manually performing a Find--FileMaker sticks its tongue out at me. There's something amiss with the script step, Constrain Found Set [Restore], but I can't figure out what.

Open the attached file, click on the Lists button, then click the GO button for the "...or Date" side of the layout; have the Script Debugger and Data Viewer open.

Everything works until the script reaches the marked script step, Constrain Found Set (under the Constrain by Date section) when it uses the variables $_DateFrom and $_DateTo. Why aren't they being processed as they should to constrain the found set? The Data Viewer shows the dates correctly and I have the ellipsis in as well so I literally just don't get it. :S

I'm sure it's something obvious that I'm missing and will kick myself later for it. TIA for your help!

Class Admittance Permit Copy.fp7.zip

[LaRetta]

Hi Rich,

You have $_DateFrom…$_DateTo in your Constrain. Restored finds require static text or variables and you have combination of the two.

Create a variable with: $_DateFrom & ".." & $_DateTo then use that variable instead.

[Rich S]

Ah! Learn something new everyday. Thanks again, LaRetta!

[Gale]

Helped me a lot.