Hey, guys, come across another dilemma.

So i've created a training database for employees but training certifications expire after three years. Does anyone know how I would make the training certifications put into the training database expire every three years? Any ideas?


You'd probably want to just add a field on the Entity with "Date Acquired" and then you can use that whenever calling to see if certs are expired. For instance a filter for expired certificates would be:

CurrDate() > AddYears(Certification.DateAcquired,3)

If you wanted them to go away after they've expired you could also create a timer that runs every day with an event that deletes any certification that matches the filter above.


You're the best. Wish I had you sitting next to me setting this thing up.