Date Format in SAP BW

[anandapr]

Hi-

Greetings.

I have a column PAYMENT DATE as character data type.
Sample Data
09/10/2010
09/11/2010

We need to create a Date Prompt to query  between the dates, Cognos by defaut returns a value like "Sep 10 2010" or " Sep 11 2010", If i pass the prompt its not working in the expected way.

I tried changing the data-type to SHORT VALUE, Can you please throw some Inputs

PS- The data source is SAP BW as no local functions are supported

Thanks
Anand

[gshilpa24]

Hi,
You cannot use to_date or to_char function in yr query ?

[anandapr]

Yes Shilpa i agree as SAP BW use OLAP functions only, we cannot use relational functions like to Cast, etc..
is there any other inputs.