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.
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