definition of the sys_updated_on field

[atyronesmith]

What is the definition of the sys_updated_on field? I have been querying tables
using the sys_updated_on field to get Incidents, Problems and Change records that
have been updated after a certain time/date. However, I came across an instance
where I modified the Opened field on an incident to a future date and the sys_updated_on field
showed the future time rather than the system time at the time of the updated.

Is this the expected behaviour?

[CapaJC]

sys_updated_on is indeed the timestamp of the last update to the record. If you're seeing a future date/time, there's something strange going on. Like you're not in the timezone you think you are, or something like that.

[atyronesmith]

I currently have a sys_updated_on value with the year 2013 in my instance for two of my
Incident records. The interesting thing about the records is that the editable fields have
been set to a future time.

I have tried to reproduce the issue, but haven't been able to so far.

Thanks for your reply.