topic Data symbolized on a date difference calculation? in Mapping Questions https://community.esri.com/t5/mapping-questions/data-symbolized-on-a-date-difference-calculation/m-p/523405#M5665 <HTML><HEAD></HEAD><BODY><SPAN>Hello, </SPAN><BR /><SPAN>I have a field in a feature class that has an inspection date.&nbsp; </SPAN><BR /><BR /><SPAN>I have a second field in the same feature class called "status" that is either "pass / fail" or "expired"</SPAN><BR /><BR /><SPAN>I'd like the status column to auto populate each day based on the difference between the current date and the inspection date.</SPAN><BR /><BR /><SPAN>For instance, if the inspection date is more than a year old from the current date - the "status" field changes to "expired".</SPAN><BR /><BR /><SPAN>How would I accomplish this?</SPAN><BR /><BR /><SPAN>THANK YOU!</SPAN></BODY></HTML> Tue, 21 Jan 2014 19:07:33 GMT goatessteve 2014-01-21T19:07:33Z Data symbolized on a date difference calculation? https://community.esri.com/t5/mapping-questions/data-symbolized-on-a-date-difference-calculation/m-p/523405#M5665 <HTML><HEAD></HEAD><BODY><SPAN>Hello, </SPAN><BR /><SPAN>I have a field in a feature class that has an inspection date.&nbsp; </SPAN><BR /><BR /><SPAN>I have a second field in the same feature class called "status" that is either "pass / fail" or "expired"</SPAN><BR /><BR /><SPAN>I'd like the status column to auto populate each day based on the difference between the current date and the inspection date.</SPAN><BR /><BR /><SPAN>For instance, if the inspection date is more than a year old from the current date - the "status" field changes to "expired".</SPAN><BR /><BR /><SPAN>How would I accomplish this?</SPAN><BR /><BR /><SPAN>THANK YOU!</SPAN></BODY></HTML> Tue, 21 Jan 2014 19:07:33 GMT https://community.esri.com/t5/mapping-questions/data-symbolized-on-a-date-difference-calculation/m-p/523405#M5665 goatessteve 2014-01-21T19:07:33Z