Learn how legal professionals use technology to adapt to consumer expectations in the 2021 Legal Trends Report

"Error on Line #: Imported record has an invalid date. it should be MM/DD/YY" Error When Importing IIF File to Quickbooks Desktop

Issue:

  • How do I resolve an incorrect date format issue for QBD?

Environment:

  • Quickbooks Desktop 2019
  • Quickbooks Desktop 2020

Additional Information:

  • QBD displays the error "Imported record has an invalid date. it should be MM/DD/YY" whenever an IIF file contains a date format that does not match the computer in use.

Answer:

To resolve this issue, either change the date formatting settings on your computer to match the IIF file in question, or change your Clio date format settings so that your IIF export matches the computer. Instructions for how to change Clio's date formatting settings can be found by clicking here.

Note that, despite the language that QBD displays, this error message does not necessarily indicate that the IIF file needs to contain the date format MM/DD/YY, only that the date format of the IIF file does not match the date format of your computer.

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality