Monday, March 8, 2021

CrystalReports: ORA-01840: input value not long enough for date format

 Error opening CustomerInfo report.

Unexpected database connector error

ORA-01840: input value not long enough for date format


The above error will happen if a date field in the database has a NULL value.


You can fix it by either changing your SQL to replace the NULL value with a valid date value such as using the function nvl(fieldName, ValidDate), or making the date field in the database not null. 

-----------------------------------------------------------------------------------------------------------------


If you have ever asked the questions below, you will benefit from reading this book.
What is the meaning of life?
Why do I have to suffer?
How can I have the life I like to have?
How can I be the person I want to be?
How can I have good and harmonious relations with others?

What is the true meaning of spiritual practice?  Check it out here.