Date countdown from 30
I'm trying to figure out how to have a field cowntdown from 30 days based on a specific date that's entered in another field. In other words, when someone creates a new record and the date is recorded, I want to have a field that counts down the days from 30 because the record needs to be completed within 30 days. Anyone know how I can go about doing this?
What would even be really cool is if the database could send an email out when the countdown is a 5 days left...but I'm probably getting in way over my head for that to happen.
Thanks in advance!