I have a point layer used for work permits. When the field crew pulls a new work permit they create a point via collector and complete attribute fields to document date permit was pulled and date permit will expire. I would like to have the ability to automate the change in symbology based on "time/date". Example, if permit is good for 14 days I want the symbol to be a green circle for the first 9 days and then change to an orange circle from days 10-14 and then change to a red circle days >14.
Any help is appreciated.