Creating an alert with a specified timing

Create an Alert for a specific time frame such as a date column with a timing no longer then 12 months. For example, if the end-user would like to change an approved date column for anything longer than 12 months from an inspection date.