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

[JohanLundgren]

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

[JayantaPoddar]

Fayaz,

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

[MuhammadFayaz]

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.

[JayantaPoddar]

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  )  )

[JoshWhite]

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].

[MuhammadFayaz]

Yes Josh, It is clear. Thanks!