COGNOiSe.com - The IBM Cognos Community

I have Fromdate prompt options likeÃ,  [Ã,  1.ALLÃ,  2. DatesÃ,  (eg:Ã,  Feb 01,2005, Mar 01, 2005 )Ã,  ( Both options included in same prompt field )Ã,  ]Ã,  Ã,  Back end is DB2. & Impromptu 7.2.Ã, 
Ã, 
When I am selecting prompt ALL it displaying 1/1/54 for all fields. SoÃ,  I used the following calculationÃ,  forÃ,  Ã, FromdateÃ,  field in the data definition.Ã, 

Fromdate is an predefined catalog prompt its data type is Date.Ã, 

If (Fromdate = 1954-01-01) then (ââ,¬ËœAllââ,¬â,,¢) else ( substring(datetostring(fromdate),6,2) +'/'+ substring(datetostring(fromdate),6,2) + '/' + substring(datetostring(fromdate),6,2) )Ã,  Ã, 

We are usingÃ,  3 SMART HOTFILES for Final IMR . I used the above calculation in my final report.Ã,  Then Iââ,¬â,,¢m getting the following error.Ã,  The same calculation is working fine for single list report.Ã, 

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RGE_FUNC_NOT_AVAIL, The function d2_d2_char is not available as an external, database or built-in function.



Thanks & Regards

ELISHA