Updating time_worked field to a value less than 1969-12-31 00:00:00 yields strange results when that field is rendered on a form.
For example, when performing a list edit on the time_worked column for any given record and pasting in the value "1969-01-01 00:10:00", upon update the cell will show the expected display value of "10 Minutes".
However, if you load the form of that record and add that field to the form, the Time Worked field will improperly render that value and display "0-8735:0-50:00".


Steps to Reproduce

1.) Navigate to, personalize the columns, and add the "Time worked" field. Upon saving, you should see the "Time worked" column available.
2.) Make a list edit for that column for any given incident record and paste in the value "1969-01-01 00:10:00". Commit the change, and you should observe that the value for that column now shows a display value of "10 Minutes".
3.) Open the form of the record you just updated, personalize the form and add the "Time worked" field to the form. Observe Time worked reads "0-8735:0-50:00" before it begins incrementing, instead of starting from "00:10:00".


This is expected behaviour. By design, date time fields and duration fields do not support any date before Jan 1st 1970.


Related Problem: PRB597114

Seen In

Calgary Patch 3 Hot Fix 1

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-06-27 07:26:04