AnsweredAssumed Answered

Range of Dates Question

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


Range of Dates Question


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.