#promptmany macro for multiple date selection

[Subz]

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 :)

[Francis aka khayman]

DUEDATE in (#promptmany(xxxxx)#)