Author Topic: #promptmany macro for multiple date selection  (Read 187 times)

Offline Subz

  • Full Member
  • ***
  • Join Date: Jul 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
#promptmany macro for multiple date selection
« on: 29 Jan 2018 07:46:48 am »
Hello Cognos Experts  :)

acutally I´m using  a prompt macro to filter a date. It is the following syntax:

where DUEDATE = #prompt('p_DUEDATE','date','current_date','','[Business Model].[p_DUEDATE]','')#

Now we want to filter multiple Dates. I thought I only have to change #prompt  to #promptmany and the "=" to "in" to make it work. But it doesnt work....  :(

The new (wrong) Syntax is:

where DUEDATE in #promptmany('p_DUEDATE','date','current_date','','[Business Model].[p_DUEDATE]','')#

The error is: expected syntax: "[", "??(", "*", "+", "-", ".", "/", "||"


Does anyone know what I´m doing wrong?

Thx alot :)

 


       
Twittear