Having a checkbox determine if a date is expired or not

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am entering employee's training certifications and I need a checkbox field that will be be checked if the certificate has expired. I have the date they received their training and I know how long each certificate is good for, but I am not sure how to formulate that for a checkbox.

Thanks in advance!
Photo of Tmarz133


  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of JimLieder


  • 238 Points 100 badge 2x thumb
You can create a Checkbox Formula field to indicate when the Certificate Expiration Date is less than todays date.  

If([Certificate Expires Date]<Today(), true)