Date Format Issue in Designer

[Former Member]

Hi Folks,

I am having Parsing Issue on "Key Date" Object in Universe. See the Code and Error underneath for your review

Code:

<FILTER KEY="0P_KEYDA"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Key Date','D',,mono,free)"/></CONDITION></FILTER>

Error: Parse Failed: Exception: DBD, The value entered is not valid. It must adhere to one of the following formats.

YYYYMMDD

DD.MM.YYYYState:N/A

This universe had created on the Top of SAP BEx Query and database is DB2. I have tried several functions like DATE(), To_Date(), To_Char(), As of Date but nothing works.

Example with To_Date():

<FILTER KEY=To_Date("0P_KEYDA", 'MM/dd/yyyy')><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Key Date','D',,mono,free)"/></CONDITION></FILTER>

Kindly advise, any kind of help will be appreciated

Thanks

[Former Member · Accepted solution]

Hi!

Did you try following:

<FILTER KEY="0P_KEYDA"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="To_Date(@Prompt('Key Date','D',,mono,free), 'MM/dd/yyyy')"/></CONDITION></FILTER>

Your key object 0P_KEYDA should be of type "Date"

ciao Hakan