topic Re: Date related symbology in Data Management Questions

Date related symbology

JodieParkes1 — Tue, 21 Jun 2016 15:16:31 GMT

Hello,

I am currently trying to get ArcGIS 10.4 to symbolise point features by utilising a date field.

All my features have a 'last reviewed' date.

Ideally, I would like ArcGIS to symbolise my features by the following by using today's date on start-up

1. If the 'last reviewed' date is over 1 year ago

2. If the date is within 1 year

3. If the date field is blank

Any ideas?

Thanks,

Jodie

Re: Date related symbology

AbdullahAnter — Tue, 21 Jun 2016 18:45:28 GMT

I think there are two method to do that symbology

Frist method ( recommended 😞

1- Add New field to your attribute table .

2- Select by attribute for records that "date is over 1 year ago" / "within 1 year" / Null

3- Calculate new field with unique value for each selection.

4-Use that field in symbology.

Second method:

1- Add your layer in TOC 3 times

2- Make a definition query for each layer with unique group as you want "date is over 1 year ago" / "within 1 year" / Null

(each layer has different expression)

3- Symbolize each layer manual.

Re: Date related symbology

JodieParkes1 — Wed, 22 Jun 2016 08:53:31 GMT

Thanks for your response - I think the first method seems more suitable.

If I were to use this method would the symbology automatically change by using the date on my computer?

Re: Date related symbology

FC_Basson — Wed, 22 Jun 2016 10:58:23 GMT

For a dynamic solution I would go with option 2 of Abdullah's suggestion. You can set your layer definition query to take the current date into account:

Over a year: ReviewDate < CURRENT_DATE - 365

Within 1 year: ReviewDate >= CURRENT_DATE - 365

Null: ReviewDate IS Null