Skip to content
logo Knowledgebase

Bank Manager: 'File format is invalid. String was not recognized as a valid DateTime’ import error

Created on  | Last modified on 

Summary

Learn how to fix the Bank Manager error below in Sage 200 Evolution.

Description

The following error message may display,

Image

when attempting to import a Bank Manager import file after selecting the ABSA Internet Banking, and perhaps other Statement Provider options.

Image

Resolution

The following steps explain how to resolve the abovementioned query:

1. Close Evolution on the local workstation where the above error message is observed.

2. Go to the local PC’s Control Panel | Region (Regional Settings) | Additional Settings.

3. Change the short date format to yyyy/mm/dd

4. When done, click the Apply button below.

 Image

5. Re-open the Evolution company and you should now be able to import the bank statement.

6. If, however the same, or other error messages are observed, close the company, restart the PC, re-open the company and try again to import.

 

View More...