COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ldsophia on 02 Jul 2009 04:58:44 AM

Title: macro prompt date default
Post by: ldsophia on 02 Jul 2009 04:58:44 AM
I am using stored Procedure to generate Query Subject.And  i am using following prompt as the input parameter:
#prompt('p_date','date','sysdate')#
the problem is the expression did not use the system curren date as its default value.How to set the prompt defaut value as the system curren date.thanks!