Date format in exported excel spreadsheet is incorrect

Legacy KB ID: 2125

Question

Why is the date format in my exported excel spreadsheet incorrect?

Answer

This can be the result of using 'illegal' characters which are characters the program does not recognize correctly.

Most likely you have used a '-' symbol to separate the day, month and year i.e.: 07/01/1975, please change all the given '-' characters to the '/' symbol and it would also help you to change the date preference to 4 digits only.

Now try exporting again to Excel.

Need more help -

Home - Reckon Community

How did we do?

Reckon Accounts Hosted: Cannot export to IIF

Adjust Payroll Liabilities message appears when importing an IIF file.

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)