New Date Import Test check capability
When you import in new data you must carefully match the date format to the format of your csv spreadsheet.
If you did not map the dates correctly an error would occur and none of the data would be imported or it might be imported for the wrong date period!
Select the Date format that you think matches the Date format from your spreadsheet and click on "Test"
If the message that appears says "Converted" you have selected the correct date format.
If it says ERROR: Missing value, this means there is no data in the column that you are trying to import. The import will work because no dates are entered
The image here shows the message "ERROR: Missing value in row 1, 2,, 3 etc). This means that the system is trying to correctly match the dates from one of the date columns, but there was no data in that column row to map to. You will see this error when you have a blank cell in a date column. As long as any other date fields in that column say that they are mapped correctly, the data will import successfully.