Error using 2 parameters built on same date in date range filter - only 1 prompt works

[Former Member]

Hi all,

     Tool is IDT 4.2.2. I have built 2 parameters named "Begin Date §(MM/DD/YYYY§)" and "End Date §(MM/DD/YYYY§)". These parameters take values from the same universe object "Date".

When I apply a filter for date range to select universe object NewDate as below, a prompt is generated only for Begin Date

The filter is as given below

@Select(Time\NewDate) BETWEEN @Prompt(Begin Date §(MM/DD/YYYY§))  AND @Prompt(End Date §(MM/DD/YYYY§))

How do I get this to work?

[former_member190895]

Hi Santosh,

Can you show me the prompt window where you are just seeing prompt for Begin Date

[Former Member]

Hi Mantu,

     Thanks for looking into this.  Here is the prompt window from webi.

[former_member190895]

Can you Just Copy your Begin Paramter and paste and give difference name. And use this one in Filter object.

[former_member190895]

If that also not working send me screen-shot of the filter and both parameters.