Chart doesn't sort date properly

LeifJohnson3

I'm trying to make a chart that shows the occurrence of certain events over time, but the chart sorts the dates incorrectly.  It's sorting based off of the day digit so since there is a 1 in the number 12 it is going before the 9th.  Any thoughts on how to change this?  I'm using data that's being brought in from a Survey123 form so I was hoping this would be compatible, but it seems like I'm going to have to change the format of the date in order for it to work properly.

rachelg_esri

Hello Leif,

Is your data stored in a text/string field, or in a date field?

Text-speaking, the chart is sorting the items properly by moving from one character to the next, left to right, and putting them in numerical order.

11/12/2019
11/20/2019
11/21/2019
11/24/2019
11/9/2019
12/1/2019
12/2/2019
12/3/2019
12/4/2019

The chart may not recognize this field as a "Date" format, so therefore it will treat it the same way it would treat any other text/string.

Can you create a field with type date, and does it act the same way?

Thanks!

Rachel G

Esri Support Services