AnsweredAssumed Answered

Range of Dates Question

Question asked by SusanMandell on Sep 7, 2011
Latest reply on Sep 8, 2011 by raybaudi

Like • Show 0 Likes0
Comment • 3

Title

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.

No one else has this question

Outcomes

raybaudi Sep 7, 2011 11:01 AM

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.

Actions

SusanMandell Sep 7, 2011 3:31 PM

Thanks for trying. Both the Date Start and the Date End are Date fields with the global storage option selected. I entered exactly what you typed both with and without the brackets and I still get the same error message.

"NSALA Expenses::Date of Expense" is a date field. I am not sure what you meant, "Note that you do not have to enter the ";" It is FileMaker that will enter that symbol for you." Are you referring to the ; after the NSALA Expenses::Date of Expense? I tried the calculation with it and without it and I still get the same message

I must be missing something stupid. Inside of the calculation field I start with NSALA Expenses::Date of Expense. There are no words before it.

As I said. Thanks for trying.

Actions

raybaudi Sep 8, 2011 11:28 AM

Inside the space for the calculation to apply to that field you must enter ONLY:

NSALA Expenses::Date Start & "..." & NSALA Expenses::Date End

nothing more, nothing less !

Actions

3 Replies

raybaudi Sep 7, 2011 11:01 AM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
SusanMandell Sep 7, 2011 3:31 PM
Mark Correct
Correct Answer
Thanks for trying. Both the Date Start and the Date End are Date fields with the global storage option selected. I entered exactly what you typed both with and without the brackets and I still get the same error message.

"NSALA Expenses::Date of Expense" is a date field. I am not sure what you meant, "Note that you do not have to enter the ";" It is FileMaker that will enter that symbol for you." Are you referring to the ; after the NSALA Expenses::Date of Expense? I tried the calculation with it and without it and I still get the same message

I must be missing something stupid. Inside of the calculation field I start with NSALA Expenses::Date of Expense. There are no words before it.

As I said. Thanks for trying.
Like • Show 0 Likes0
Actions
raybaudi Sep 8, 2011 11:28 AM
Mark Correct
Correct Answer
Inside the space for the calculation to apply to that field you must enter ONLY:

NSALA Expenses::Date Start & "..." & NSALA Expenses::Date End

nothing more, nothing less !
Like • Show 0 Likes0
Actions

Range of Dates Question

Title

Post

Outcomes

Related Content

Recommended Content