Search date range. Ununderstandable error

[Enigma20xx]

Understandable for a newbie, there must be an explanation I still don't know.

Script step: Perform Find.

I have two variables: $FirstDayOfMonth, $LastDayOfMonth

Into the find I set:

$FirstDayOfMonth...$LastDayOfMonth (I use three points). Doesn't work.

If I use the insert operator to insert the three point. Doesn't work either.

If I set another variable: $RangToFind [$FirstDayOfMonth & "..." & $LastDayOfMonth] and use it in the Perform Find step WORKS.

What am I doing wrong in the first two ways?

[comment]

You cannot use calculations in the Perform Find [] step. Try instead:

Enter Find Mode []

Set Field [ YourTable::YourDateField ; $FirstDayOfMonth & "..." & $LastDayOfMonth ]

Perform Find []

[Enigma20xx]

Thank you comment.

I was a bit confused because using ...$AnyVar worked and $AnyVar1...$AnyVar2 didn't.

If calculations can't be used in that step, what's the difference between ..."+"$1 and $1"+"..."+"$2? "+" symbol is just to explain it.

Working with another variable that include both works fine in Perform Find.

[comment]

using ...$AnyVar worked

There is a bit of a history here. At first, you could only have used literal text in stored criteria, such as "Fred" or "<100". Only since version 11, you can also use a single variable - but still no expressions that need to be evaluated. For more, see:

http://help.filemaker.com/app/answers/detail/a_id/7590

[eos]

There is a bit of a history here. At first, you could only have used literal text in stored criteria, such as "Fred" or "<100". Only since version 11, you can also use a single variable - but still no expressions that need to be evaluated. For more, see:

http://help.filemake...etail/a_id/7590

… but you can calculate the expression beforehand and pass it to the variable you use as criterion in Perform Find. You don't even need to Enter Find Mode first.

[LaRetta]

you can also use a single variable

That is what Michael said. Believe me ... he knows what can be used in finds.

It usually works best to use Enter Find Mode() because then the criteria is easy to see when viewing the script whereas Perform Find() provides no such information. Sometimes I use Perform Find() if it is very simple. :^)

Edited June 3, 2012 by LaRetta