Skip to main content
Question

syntax error

  • September 29, 2017
  • 0 replies
  • 28 views
Syntax error for Max([Referral Date],[2nd Referral Date],[3rd Referral Date]) If(<[Most Recent Referral Date], null)

We are trying to leave a field blank if it is less than the "most recent referral date"field. This formula works for our max value between referral dates, but not for the If statement 
      This topic has been closed for replies.

      • ChrisChris
      • Quickbase Alumni
      • September 29, 2017

      if(

      max([referral date],[2nd referral date],[3rd referral date])<[most recent referral date],null, {else?}

      )

      • ShannonMcFarlin
      • Author
      • Quickbase Alumni
      • September 29, 2017

      Thank you for such a quick response! 

      That did not work.

      First I copied and pasted your code as you sent it, it did not work. I ended up with the following:

      Max([Referral Date],[2nd Referral Date],[3rd Referral Date])
      If(
      Max([referral date],[2nd referral date],[3rd referral date])<[most recent referral date],null,{else?})

      It keeps giving me the following error: "There are extra characters beyond the end of the formula"

         
      • ShannonMcFarlin
      • Author
      • Quickbase Alumni
      • September 29, 2017
      Any ideas what could be wrong?
      Again, thank you for your help!!!
      • ChrisChris
      • Quickbase Alumni
      • September 29, 2017

      Hi,

      The {else?} was a message to you to provide an else condition.

      If you do not have an else condition, remove the , {else?} including that comma before the left brace, so that the code says, .... date],null )

      Terms & ConditionsAccessibility statement