When conducting an assets import, integers representing a datetime parsed using Windows NT time format do not retain the two most significant digits of the year

XMLWordPrintable

    • Severity 3 - Minor

      Issue Summary

      When conducting an assets import, integers representing a datetime parsed using Windows NT time format do not retain the two most significant digits of the year; any year is set to 20xx, even if the provided year does not match the 20 prefix.

      Steps to Reproduce

      • Adjust your Jira look and feel datetime format to have a four digit year (to allow you to see the incorrect year)
      • Create a new empty assets object schema and assets object type, which includes a new attribute of type 'DateTime' 

      • Construct a csv with the following content
      name,integer_datetime_representation
      "Test Object",638292024000000000


      (Representing a date in year 3623 when parsed using WindowsNT datetime format)

      • Create a new csv import configuration for the new assets object schema, uploading the above csv file (all other configuration can remain unchanged).

      • Create an object type mapping to the new csv import (all configuration in the create modal can remain default), set data locators and matching assets attributes after creation.

      • Run a sync.


      • Review the newly imported assets object.

      Actual Results

      Imported assets object shows a date in 2023.

      (note this server is configured with UTC timezone)

      Expected Results

      Imported asset object should show a date in 3623.

      (note this server is configured with timezone offset of GMT +09:00)

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

      Versions Tested

      Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below: 

      Testing Requirements Version Affected Version
      Customers Reported Version    
      Most Recent Bug-Fix Release    
      Previous Major Release    
      Most Recent LTS 11.3.0 No
      Previous Supported LTS 10.3.13 Yes
      Previous Supported LTS 5.12.29 Yes
      Other Versions.. 11.2.0 Yes
      (Add rows as needed)    

        1. image-2025-11-25-11-04-43-786.png
          image-2025-11-25-11-04-43-786.png
          55 kB
        2. image-2025-11-25-11-04-29-820.png
          image-2025-11-25-11-04-29-820.png
          77 kB
        3. image-2025-11-25-11-01-51-924.png
          image-2025-11-25-11-01-51-924.png
          138 kB
        4. image-2025-11-25-11-00-29-127.png
          image-2025-11-25-11-00-29-127.png
          16 kB
        5. image-2025-11-25-10-57-08-896.png
          image-2025-11-25-10-57-08-896.png
          77 kB
        6. image-2025-11-25-10-54-56-614.png
          image-2025-11-25-10-54-56-614.png
          47 kB
        7. image-2025-11-25-10-54-43-865.png
          image-2025-11-25-10-54-43-865.png
          49 kB
        8. image-2025-11-25-10-52-44-268.png
          image-2025-11-25-10-52-44-268.png
          62 kB
        9. image-2025-11-25-10-52-07-366.png
          image-2025-11-25-10-52-07-366.png
          39 kB
        10. image-2025-11-25-10-51-10-148.png
          image-2025-11-25-10-51-10-148.png
          113 kB
        11. image-2025-11-25-10-50-13-052.png
          image-2025-11-25-10-50-13-052.png
          106 kB
        12. image-2025-11-25-10-49-34-400.png
          image-2025-11-25-10-49-34-400.png
          52 kB
        13. image-2025-11-25-10-47-35-299.png
          image-2025-11-25-10-47-35-299.png
          79 kB

            Assignee:
            Unassigned
            Reporter:
            Nick Divall
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: