Discussions

Expand all | Collapse all

Having a checkbox determine if a date is expired or not

  • 1.  Having a checkbox determine if a date is expired or not

    Posted 06-26-2018 12:55
    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!


  • 2.  RE: Having a checkbox determine if a date is expired or not

    Posted 06-26-2018 14:21
    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)