Hello,
I am trying to order the records i have in a gdb by the date field and represent it in a chart. I have records for random days in several months.
If i parse the dates, it shows a coherent graphic with the values for the specific days, however, the months are shown as equal intervals and with no data for the days missing (as expected).
If i want to show in the chart only the days when i have data and to sort it by the date field in chronological order and without parsing the dates, the data field is converted into strange integer numbers like 1702598400000 and the actual data in the table is denaturated (changed) into an untransparent form.
Does anyone have any idea how to better work with the dates in the dashboard or is it an ESRI glitch as the platform being ArcPRO, ArcMAP or Enterprise can´t really properly handle the data field?
The format i use for the data is dd/mm/yyyy.
Maybe someone from ESRI can address this problem.
Thank you.
