date format throwing error in cognos 10 but not in cognos7

[inu]

Hi Team,

I ran one report in cognos 7 , it gives output , but same report while executing in cognos10, it throws  error , attached.

the syntax is :
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) >= cast_date(?DateFrom?) and
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) <= _add_days(cast_date(?DateTo?);1)

Kindly Suggest me ,whether anything needs to be added.

Thanks in advance.

Regards
Inam

[MFGF]

Hi Team,

I ran one report in cognos 7 , it gives output , but same report while executing in cognos10, it throws  error , attached.

the syntax is :
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) >= cast_date(?DateFrom?) and
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) <= _add_days(cast_date(?DateTo?);1)

Kindly Suggest me ,whether anything needs to be added.

Thanks in advance.

Regards
Inam

Hi,

Did you make any effort to research the error? I just took the error code (ORA-01830) and put it into Google and got myriad hits. Here is one:

http://stackoverflow.com/questions/20219363/ora-01830-date-format-picture-ends-before-converting-entire-input-string-sele

It is an error from your ORACLE database saying you should not be relying on implicit date conversion in your expression.

What data type is STATUS_DATETIME? Why are you using a cast_date() function?

MF.