x Want to participate? Join the group to interact

Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

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

State Not Answered
Replies 1 reply
Subscribers 118 subscribers
Views 4005 views
Users 0 members are here

Browse Forums

Announcements

269

260

Databases and Operating Systems

759

Financials Suite

General Discussion

10k

Operational Suite

852

Reporting and Analytics

Reports, Macros, and Customizations

876

Sage CRM for Sage 300

183

410

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

Posted By 4139750 over 6 years ago

Error message when running report in Sage Intelligence. This was working last week.

Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.
Number : -2147217913
Source :
Driver Error : 241
SQL State : 22008

0 Jay Converse Acumen over 6 years ago

You probably have bad data. Check GLPOST.JRNLDATE for something like 2018411 instead of 20180411.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

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

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING