Hello,
We noticed some very strange results in our Metrics reports. The "Create to Resolve Duration" metric results show several hundred Incidents that have a Duration in thousands of years.
I was able to determine that the cause is the Sys Created On date on those affected Incidents is very wrong. There are several hundred incidents that have a Start Date from thousands of years ago in the *first century*, such as year 0019 examples 0019-12-10 23:44:29 and 0023-04-10 23:50:56.
The metric is calculating the difference between Created On date and the Updated On date, so that's why those durations are very large.
gr.start = current.sys_created_on;
gr.end = current.sys_updated_on;
gr.duration = gs.dateDiff(gr.start.getDisplayValue(), gr.end.getDisplayValue());
Since the Sys Created On date is generated by the system in the back-end, what could have caused this issue?
The problem seems to have only affected a subset of incidents thus far but has skewed our manager's reporting capabilities.
To summarize, the Sys Created On date on several hundred Incidents is showing dates from thousands of years ago.
