Date Prompt Value to Oracle SP

[Creeder]

Dear All,

I am really new to Cognos ReportNet.

How do I customized a Date Prompt Value to a value acceptable by the oracle SP?

For example the value in my Query Subject Definition argument is

#prompt('p1','characterLength16','01-FEB-2006')#

Basically the Oracle SP accepts a string value with the format of DD-MON-YYYY.

How do I passed the value from the date prompt and convert it to the above format and type as well?

Any help is greatly appreciated.

Regards.