Scripting

Hi, we have users who check out mobile items like Laptops, Projectors and Tablets. We are looking for the best way to keep track of who has them, for how long and let the user know when it is due, automatically. I have set up a ticketing queue so that they can request and item. When they pick the item up we change the ticket status to "picked up". Right now I have a rule set so when a ticket is in this status for 14 days it will send an email informing the user that the item is due and change the ticket status to "Due". What I would like is to have the status change and email sent based on the due date in the ticket and not a set 14 days. This way if someone needs the item for shorter or longer we could do that. Does anyone know if KACE Rules are able to do that? If able could someone share how to accomplish this.