Error: “An Unexpected Error Had Occurred | Parse of Date/Time “Xx” Failed with Date Format “M/D/Yy H: Mm a” in Time Zone America/Chicago” CSV Import of FAM Alternate Depreciation

The user encountered the above error during the CSV Import of FAM Alternate Depreciation.

The error is due to a value in the column(s) of the imported file where a date value is expected but an integer was entered instead.

The error description can be translated as follows:

  • Parse of date/time xx where xx refers to the integer entered by the user in the column of the CSV file
  • M/d/yy h: mm a is the selected format in the Date Format field in Home > Set Preferences > General > Formatting
  • America/Chicago is the time zone selected in the Time Zone field
Solution

The user must enter in the CSV file date in the format M/d/yy h: mm a in the column where a date value is expected by the system.

1. Open the CSV file

2. Refer to the Date/Time column

3. Make sure that the values entered in this column correspond to the format set in the user’s Date/Time Format preferences in Home > Set Preferences > General tab, Formatting section 

4. Save the changes made

5. Re-import the file

Leave a comment

Your email address will not be published. Required fields are marked *