Having a checkbox determine if a date is expired or not

  • 0
  • 1
  • Question
  • Updated 5 months 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

Tmarz133

  • 70 Points

Posted 5 months ago

  • 0
  • 1
Photo of JimLieder

JimLieder

  • 188 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)