Certification duration question.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have the following formula in the Expiration Date field:

If(IsNull([Course - Qualifcation Duration (Months)]), "", AdjustMonth([Qualification Date], [Course - Qualifcation Duration (Months)]))

I am trying to get the expiration date to stay blank if their is no Qualification Duration indicated. The formula isn't working however. Can anyone assist? Any help would be appreciated.

Photo of Eric

Eric

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
The formula syntax editor is not liking your formula because it treats the empty quotes as text.

Try this.  Because it is "silent" on the else, the result will be null if the course duration is null.


IF(not IsNull([Course - Qualifcation Duration (Months)]), AdjustMonth([Qualification Date], [Course - Qualifcation Duration (Months)]))

You an also do this, but that last null is not really necessary.
IF(not IsNull([Course - Qualifcation Duration (Months)]), AdjustMonth([Qualification Date], [Course - Qualifcation Duration (Months)]), null)
Photo of Eric

Eric

  • 0 Points
While I didn't get an error, it still populates the expiration date with the qualification date.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
Oh, change the Field properties on that duration months field to NOT treat blank as null.  So uncheck that box.
Photo of Eric

Eric

  • 0 Points
Thanks for the help!