The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 . (WIS 10901)

Hi Experts,

I am using BO 3.2, and Connection DB2.

I am facing the error "

The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007

. (WIS 10901)" while using the object in webi for a report..

Please find the existing code below.

SELECT

date(DB2ADMIN_It_PRO_pck.START_DATE )

FROM

DB2ADMIN.It_PRO DB2ADMIN_IA_PRO_pck

I tried to fix this issue by updating the code as

SELECT

date(DB2ADMIN_It_PRO_pck.START_DATE )

FROM

DB2ADMIN.It_PRO DB2ADMIN_IA_PRO_pck

WHERE

( DATE(( DB2ADMIN_It_PRO_pck.START_DATE)) = 'DD-MM-YYYY' ) which is not working.

The object data type in universe is in DATE and code " date(DB2ADMIN_It_PRO_pck.START_DATE )"

Can anyone check what i can do?