Hi All,
I am facing a problem in using a Cognos variable based on a date input parameter.
My requirement is, to display Page 1 of report if the input date is greater than '01-Apr-2019' else Page 2.
I am trying to use the following under 'Edit variable' screen :
case when string2int32(paramvalue(<parameter name>)) > 20190401 then 1 else 2 end
Also in the page level I have rendered the value 1 and 2.
However I do not see the variable working as expected.
Any suggestions would be appreciated.