Inventory One-Off Upload - Last Used Date

[goody612]

When doing a one off upload of inventory to include installer evidence, I notice that the last used date isn't getting populated from the template.  Has anyone done this before and been successful?  I was thinking may the date format is wrong, but I am using the same format that is used with other import templates like the PO template.  Thanks!

[ChrisG · Accepted solution]

Getting the date format right in inventory spreadsheet data can be tricky. What date format are you using?

I think if you use text cells with the format yyyy/MM/dd then you should be OK.

Also see the following known issues which are in this space:

• Usage date format described in inventory spreadsheet schema documentation doesn't match format accepted by import code (IOJ-2227030)
• InsertComputerEvidenceFrom*EvidenceUsage import writer steps may fail with error due to usage date values in invalid format: "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" (IOJ-2122692)

[goody612]

Thank you, the below date format worked.

yyyy/mm/dd