calculations - separators

[harry8]

What does this message mean and what do I do (or look for) to get rid of it?

"There are too few separators in this function."

thanks, Harry

[andygaunt]

Harry,

Basically this means that you are missing a comma somewhere in your calculation field.

To check your calculation look for where a comma should be.

In a case statement:

Case ( test1 , result1

[harry8]

Here's how I wrote it:

If(Notes Office = "Complete") , "", or

If(Today-Sort Date-30>0, (Today-Sort Date-30), "0" or Case (Today-Sort Date-30 > 0, (Today-Sort Date-30) >=0, "0"))

I'm receiving the dialog box: "There are too few separators in this function." How can I make it work?

thanks, Harry

[Vaughan]

First of all DO NOT use TODAY, use the Status(CurrentDate) function.

You are missing a ")" just before the "or" on the first line. Actually now that I look at it, you are missing a ")" before each "or" expression on every line.

I'm not sure what your logic is, but you don't need the "or" statements at all. Just make sure that there is exactly the same number of "(" as ")" in the statement: it should end with something like ")))" because you have nested Ifs and Cases.

[ March 11, 2002, 04:48 PM: Message edited by: Vaughan ]

[danjacoby]

Lots of problems -- replace the whole thing with a "Case" statement:

Case (Notes Office = "Complete", "",

Status(CurrentDate) - Sort Date-30>=0, Status(CurrentDate) - Sort Date-30, 0)

Simply stated, if the field "Notes Office" equals "Complete" then the calc field is empty.

If not, then if the current date minus the Sort Date minus 30 is greater than or equal to zero, it enters the calc.

Otherwise, it enters "0".

Once you finish that, take a good look at the syntax of the "If" statement -- you're adding a bunch of extra junk.

[harry8]

danjacoby,

YOU THE MAN!!! Your solutions appears to work. Thanks to you and all others who assisted me -- I will need your able help in the future.

Harry