What is the date format to be used in template files for importing data into the system?
The date format must be: MM/DD/YYYY.
For example: August 1st, 2022 should be written on the data import template file as 08/01/2022.
The following date formats will cause the system to show an error, and should all be corrected so that the cell shows 08/01/2022 (MM/DD/YYYY).
- 8/01/2022
- 08/01/22
- Aug-2022
- Aug-22
- Aug-01/2022
- Aug-01/22
Related Articles
Importing Multiple MMRs Using Spreadsheet Template
By clicking on the Create section of the MMR menu, you can import your MMRs. Here you will learn how to import MMRs using a .xlsx file: 1. On the left side menu of the screen, click on Vehicles. 2. Under the Vehicles menu item, click on MMR. ...
What is the minimum number of characters for the "VIN Number" to be used in template files for importing data into the system?
The minimum number of characters for the "VIN Number" is 17.
What information is needed to get started after I subscribed to mygroundforce?
After you have completed your subscription to mygroundforce, we will need the following information to be able to proceed with the data loading (onboarding) into the system for you. For the Excel Templates, if you have the information we asked you ...
Odometer Update for Non-TruckSpy Customers
In the Odometer Update tab, you can update the odometer reading for all your active vehicles. Here is how you access the upload odometer update tab: On the left side menu of the screen, click on Vehicles. Under the Vehicles menu item, click ...
How to change list separator from semicolon to comma when saving CSV files
If, when opening your CSV file with Notepad, you see semicolons instead of commas separating columns you have to change your Windows region to English (United States) and, in the list separator, replace the semicolon with a comma. Here you will learn ...