I am getting the following error when running a report for one fiscal period but not others

[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.

I have searched the forum, but not able to make any of the suggested solutions work.

Any assistance would be appreciated.


Views: 110

Reply to This

Replies to This Discussion

Hey Debby

This usually happens when you have an account number which looks like a date, for example if you have an account like 101217, it confuses the system into thinking it might be a date, 

Try this, open your report in design mode and convert the account column or column which might have numbers that could look like a date into a Text column, it should resolve this 



The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service