When trying to use the Intelligence reporting I get the following error;

[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]'' is an invalid date value. If using '0000-00-00', replace it with NULL for a constant, or IS NULL in expressions.

I have tried to change this to many things and different kinds of reports but with no success. Any ideas?

Views: 63

Reply to This

Replies to This Discussion

Hi Michael,

You could try using COALESCE

Regards

Chole

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service