Forum Discussion

Tmarz133Tmarz13's avatar
Tmarz133Tmarz13
Qrew Member
6 years ago

Having a checkbox determine if a date is expired or not

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!

1 Reply

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