Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
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 - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • 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
KB0681662

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


820 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Description

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 incident_list.do, 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".
 

Workaround

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

 


Related Problem: PRB597114

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.