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!
Mar 03, 2022 07:13 AM
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:
Mar 03, 2022 07:18 AM
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:
Mar 03, 2022 07:18 AM
Thank you, the below date format worked.
yyyy/mm/dd
Mar 03, 2022 07:58 AM