AnsweredAssumed Answered

Let function

Question asked by carolynhaywood on Mar 12, 2010
Latest reply on Mar 12, 2010 by fitch

Title

Let function

Post

I'm trying to use the let function and the case function in a calculation:

 

Let (  [TotalInvoice = "T" ; interest = "I";  Get (currentDate) - invoice date = "date" ]; Case ( date  ≥ 30; T + I); T)

 

I keep getting an error message saying I need a text constant,  number, field or parentheses  on the first parentheses of currentDate.   I don't know what else to do. 

 

Thanks,

Carolyn Haywood

Beginner

 

FMP 10 Advanced Mac 10.6.2

Outcomes