Skip to main content
Question

Having a checkbox determine if a date is expired or not

  • June 26, 2018
  • 0 replies
  • 35 views
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!
    This topic has been closed for replies.

    • JIMLIEDER1
    • Registered
    • June 26, 2018
    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)
    Terms & ConditionsAccessibility statement