Passing parameters to SQl Server Stored Procedure from Cognos Framework Manager

[Cognos Talk]

version 10.2

I imported stored procedure into the Framework Manager and it uses two parameters: @from and @to dates
(PROCEDURE up_get_data( :@From IN date, :@to IN date );


Then for definition entering value I put #$pDateFrom{prompt('pDateFrom','Date')}# for start date and #$pDateTo{prompt('pDateTo','Date')}# for end date.
I validated query subject and it said that the parameter values are null.
I clicked on test and entered the values  2000-01-01 and 2014-04-10 click ok and nothing came back from the database.
When I looked at the query information 
It was showing  CALL "tps_reporting"."aaa"."up_get_data" ( null, null ) for values for native query.
when tracing from database server it is passing the parameter properly. The database is sql server 2008.
Can someone help with this mater, it is urgent.
Thank you very much for your time and support

[MFGF]

What do you see if you use ?pDateFrom? as the Start Date value and ?pDateTo? as the End Date value?

MF.

[Cognos Talk]

Please take a look at the screenshots attached.
Inside Cognos it does not update any parameters, generating and showing null values in query information window, but in the database with tracing log it shows the date passing.

[Cognos Talk]

Thank you for your reply, it did work when I entered simply ?pFromDate? and ?pDateTo?
Many thanks, it works now!!!

[MFGF]

Simple solutions are often the best :)

Glad it works!

MF.

[Cognos Talk]

Yes, I agree, instead of using complex macros!!!
Much appreciated!!!