topic Symbology: How can I make a symbol to change color based on overdue date value in ArcGIS Mapping and Charting Questions

Symbology: How can I make a symbol to change color based on overdue date value

JohanLundgren — Tue, 10 Feb 2015 08:10:52 GMT

I'm exploring symbology with ArcMAp 10.2. I created a feature class and it consists of a field called EndDate of type Date. Next, I would like to create a layer and configure symbology, so that the symbol color changes to red once the date is overdue.

I opened the Layer Properties dialog and the tab Symbology. In the 'Show section, you find Quantities and 'Graduated colors'. But my field (EndDate of data type Date) is not shown in the field called 'Value'.

Any ideas about how I can solve this is very much appriciated.

Are there more possibilities with symbology in ArcMap 10.3?

//Johan

Re: Symbology: How can I make a symbol to change color based on overdue date value

JayantaPoddar — Tue, 10 Feb 2015 09:12:37 GMT

Hi Johan,

What is the format of your EndDate field values (e.g. MM/DD/YYYY)?

Re: Symbology: How can I make a symbol to change color based on overdue date value

JohanLundgren — Tue, 10 Feb 2015 09:22:28 GMT

I would like to have the ISO format: YYYY-MM-DD

//Johan

Re: Symbology: How can I make a symbol to change color based on overdue date value

JayantaPoddar — Tue, 10 Feb 2015 10:20:28 GMT

Hi Johan,

Thank you for the information.

You can create a new field with datatype Long in attribute table. In its field calculator, paste the following

Int (Left( [EndDate], 4 ) & Mid( [EndDate], 6, 2 ) &Right( [EndDate], 2 ) )

Then use the above field to symbolize the data.

Note: The EndDate Format is in YYYY-MM-DD format.

The field name of your EndDate field is "EndDate".

Hope it will solve the issue.

Thanks,

Jay

Re: Symbology: How can I make a symbol to change color based on overdue date value

JohanLundgren — Tue, 10 Feb 2015 11:03:18 GMT

Many thanks for your help Jay!

I have two fields now EndDate and CalculatedEndDate. The field CalcaulatedEndDate is added with your code, as shown above. When entering and saving a value like 2015-02-10 in EndDate it shows <null> in CalculatedEndDate. Is that the correct result?

Also, do you have any tips on where I add a calculation to show a symbol in red color on overdue, by using my new field CalculatedEndDate?

Re: Symbology: How can I make a symbol to change color based on overdue date value

JayantaPoddar — Tue, 10 Feb 2015 11:45:42 GMT

Hi Johan,

It should show the values without the "-" sign.

Make sure your system Regional Date setting is in same format. And CalculatedEndDate is in Long datatype.

Considering the due date is same for all records, any value more than the CalculatedEndDate is overdue.

Change the symbology accordingly.

Thanks,

Jay

Re: Symbology: How can I make a symbol to change color based on overdue date value

JohanLundgren — Tue, 10 Feb 2015 12:58:48 GMT

Thanks Jay!

I can now see the new calculated value for date.

//Johan

Re: Symbology: How can I make a symbol to change color based on overdue date value

JoshWhite — Fri, 13 Feb 2015 15:01:16 GMT

Jay,

How would you do it if the original date field is MM/DD/YYYY format?

Nevermind I did some tweaking and came up with

Int (Right( [Date], 4 ) & Left( [Date], 2 ) &Mid( [Date], 4, 2 ) )

So mine went from 01/01/2012 to 20120101

Re: Symbology: How can I make a symbol to change color based on overdue date value

JayantaPoddar — Sat, 14 Feb 2015 19:23:20 GMT

You are right Josh...

Re: Symbology: How can I make a symbol to change color based on overdue date value

MuhammadFayaz — Thu, 27 Aug 2015 10:05:56 GMT

Dear Jay,

What if my date format is DD/MM/YY ?

Re: Symbology: How can I make a symbol to change color based on overdue date value

JayantaPoddar — Thu, 27 Aug 2015 11:05:25 GMT

Fayaz,

What is the range of your data's date (mention the Start year)?

Re: Symbology: How can I make a symbol to change color based on overdue date value

MuhammadFayaz — Thu, 27 Aug 2015 11:16:53 GMT

Thank you Jay for your quick response.

I am using Arabic (Hijri Dates) and the date range is like 01/01/1424 to 01/01/1460.

Re: Symbology: How can I make a symbol to change color based on overdue date value

JayantaPoddar — Thu, 27 Aug 2015 11:49:11 GMT

If the date format is DD/MM/YYYY, use the following expression using field calculator in a new field (LONG)

Int (Right( [Date], 4 ) & Mid( [Date], 4, 2 ) & Left( [Date], 2 ) )

If the date format is DD/MM/YY, use the following expression using field calculator in a new field (LONG)

Int (Right( [Date], 2 ) & Mid( [Date], 4, 2 ) & Left( [Date], 2 ) )

Re: Symbology: How can I make a symbol to change color based on overdue date value

JoshWhite — Thu, 27 Aug 2015 13:02:54 GMT

Muhammad,

Don't forget in Jay's example that [Date] is the field name that holds your date so it might not necessarily be [Date].

Re: Symbology: How can I make a symbol to change color based on overdue date value

MuhammadFayaz — Tue, 01 Sep 2015 06:35:46 GMT

Yes Josh, It is clear. Thanks!