Set Field *not* setting the field

[ron G]

The objective is to do a 'find' on all records with a expiration date (expDate) between two dates.

By running debug I can see the cursor in my script NOT go into the designated field. If I type the code into the field I am told it is not in the correct format. What do you see is wrong?

(I sure wish FM more better information on proper syntax for this)

Set Field [OptionTransactions::expdate; ">=" & Global::g.LowerTransactionDate "and" & "<=" & Global::g.upperTransactionDate]

(I use the 'unified symbols for less than and greater than and equal to)

[ron G]

Got it!

Turns out I needed to use an elipses ...

between the two fields and that created the desired range.

[LaRetta]

(I sure wish FM more better information on proper syntax for this)

Upon reading several of your posts, it appears that you are not familiar with FileMaker Help. Here is where it explains searching for date ranges; there actually is quite a bit said about it:

Finding Ranges of information

... and if, with your version of FileMaker open, you type F1, it brings up help. Typing [color:green]find date range in search box would have provided you with instant answer. I get the feeling you spend quite a bit of time struggling when general answers are close by.

[ron G]

You are right about 'struggling' sometimes. For example, right now I am trying to get the proper syntax for a Set Field. I go to help and type "set field" (with and without the "") and get a *LOT* of irrelevant information. Then I go into the scripting step of Step Field (In my script) and press f1... nada ... zippo ... zero ... zilch

I hope you can better appreciate the problem. I am a conversion from dBase III (do you remember that 'grand daddy' of databases?) 8-)

[LaRetta]

I hope you can better appreciate the problem.

It may surprise you what I can appreciate ... I (and everyone here) have been in your exact situation. You cannot expect to learn a new program instantly without study. Even if you had a magic Mentor that would give you every answer instantly, you would NOT REALLY LEARN from the answers. You must discover.

If, when you open FileMaker, you press F1, you will find Help. Or, look up at the FileMaker menu bar (far right). You are not the first new person to FileMaker ... we all were. I come from old dBase IV and other such goodies.

You may have to 'wade' through Help a bit but you'll be surprised what you learn as you wade. In fact, I would suggest you READ Help (all of it). Be willing to search for your answers (and put in a bit of sweat). Along the way, you will discover many cool, important things.