HELP!

[Matthew R White]

This is the calculation I'm trying to get to work:

 

 

If (IsEmpty(Quoted Date) ; Get(CurrentDate) - New Quote Enter Date)

Else ; (Quoted Date - New Quote Enter Date)

 

 

The first line seems to work, but Filemaker is now saying (cannot find specified field regarding the Else.

 

Background: I've got a field (Elapsed Days) that I would like to calculate automatically the time elapsed between current date and New Quote Enter Date, however once a customer has been quoted, I have an auto enter date field called Quoted Date that I would like this Elapsed Days field to reflect, but only to calculate when there is something in the Quoted Date field, until the customer has been quoted there is nothing in the field.

 

Thanks!

[Lee Smith]

Please do NOT use Help as a title, instead use something that represents your problem. In orthers  "How to calculate elapse time between dates time or whatever the case maybe.

 

The calculation could be something like.

 

Date End - Date Start

[doughemi]

Lose the word "else" in your calculation. The Else statement is used only as a script step.  The calculation format is

 

If(ExpressionToEvaluate; ExpressionIfTrue; ExpressionIfFalse)

 

The line breaks are ignored by FM.

[Matthew R White]

That worked, thanks!