Invalid Year error when refreshing the report with date prompt

[rishabh_singhania]

Hi All,

I am working on BO XI 3.1 with Informix database.

When refreshing the report without any date prompt the report is running fine,but when applying the date prompt it is giving the error message

"Invalid year in the date".

I have tried changing the value in the advance tab of the object property to 'yyyy-mm-dd hh:mm:ss'

But it also din't work for me.

Please suggest.

Thanks and Regards,

Rishabh

[rishabh_singhania]

Hi Experts,

Thanks for your suggestions.

Since changing the PRM file was not a fesiable solution for us.

We have manged to find a work around to solve this issue

We have created the filters at universe level with following formula for all the date objects which we ere using at report level as a prompt:

@Select(classname\objectname)=TO_DATE(@Prompt('Enter Date:','D',,mono,free,not_persistent), '%Y/%m/%d')

Although when we parse this formula it wil give an error message saying 'illigle operation',

still it will work when we use this at report level.

Thanks and Regards,

Rishabh

[Former Member]

Hi,

Whats your source datatype? Also how does the date value look (dd-mm-yyyy)? Give some examples.

Arun

[rishabh_singhania]

Hi Arun,

When viewing the value of date field in universe it's in the format "yyyy-mm-dd".

Also in the prompt when i tried selecting the LOV'S its in the format "dd/mm/yyyy hh:mm:ss" and gives error on refreshing the report.

Thanks,

Rishabh

[former_member190895]

Please check at the database which format is executable.

[rishabh_singhania]

Hi Mantu,

I checked at the database end the format is yyyy-mm-dd.

I even tried changing the date format in PRM file, still the same error.

Thanks and Regards,

RIshabh