cast Prompt in framework managerhi i am trying to upload my sp in Framework man

[div_1234]

hi

i am trying to upload my sp in Framework manager and i have 1 parameter in sp which is datetime format.

when i am trying to create parameter like #prompt('date1') # it gives me error like
incorrect date format.should be CCYY-MM-DDThh:mm:ss
.

i tried to_date(#prompt('Start_Date')#,'yyyy-mm-dd')
  and also cast,but still getting same error

Any help?

[Arsenal]

is this parameter going to be supplied from within the report?

If so, you can just put in #prompt('param1','token')#

[div_1234]

hi
what you mean by token here,this parameter will come from stored procedure

[MFGF]

Surely the parameter will be passed to the stored procedure, not derived from it?  What Arsenal suggested is a prompt macro to prompt for the parameter which is then passed to the stored procedure, and the 'token' part is in the place where a data type would normally be specified in the prompt macro. Token simply means that nothing is assumed about the data type and the value is passed as-is.

Regards,

MF.

[div_1234]

ok.i did like this

#prompt('param1','datetime') it gives me error like param1 is not found in stored procedure.



RQP-DEF-0177 An error occurred while performing operation 'sqlExecute' status='-69'.
UDA-SQL-0043 The underlying database detected an error during processing the SQL request.
[Microsoft][SQL Server Native Client 10.0][SQL Server]pram1 parameter not found in Validation_result

Any help