Title
Range of Dates Question
Post
I am trying to create a script to have the user enter a start and end date, then have the script perform the find. I found the documentation on how to do it in the knowledge base. However, when I get to the "Insert Calculated Result" step I run into problems in the calculation window.
I have tried every combination of what was in the instructions. One set of instructions had quotes around the ... the other did not. I tried:
NSALA Expenses::Date of Expense;NSALA Expenses::Date Start & ... & NSALA Expenses::Date End
Each time I get the error message "an operator (e.g. +, -, *, ...) is expected here (and everything after the first ; is highlighted)
I have tried every combination of operators and symbols of inclusion ( [ { I can think of and can't get it to work.
Please help. This is a really crutial part of the database I am trying to build for National Mill Dog Rescue and I don't want to let them down.
Thanks.
Set Field [ NSALA Expenses::Date of Expense // this is the name of the field ; NSALA Expenses::Date Start & "..." & NSALA Expenses::Date End // this is the calculation that will set the field ]
where Date Start and Date End are two global fields.
Note that you do not have to enter the ";" It is FileMaker that will enter that symbol for you.