Date prompts in slicer

[Cognos8]

Hi,

I am trying to convert the date prompt filter to  slicer for performance tuning. Below function does not throw error and not filtering the data as per selected date in prompt. Date prompt is chosen not tree prompt. Also what is the DMR function to convert in to specific date format. Please shred some light on this.

filter(
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)],
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)].[Date (ship date)]
between ?Parameter1 and ?Parameter2?
)

[MFGF]

Hi,

I am trying to convert the date prompt filter to  slicer for performance tuning. Below function does not throw error and not filtering the data as per selected date in prompt. Date prompt is chosen not tree prompt. Also what is the DMR function to convert in to specific date format. Please shred some light on this.

filter(
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)],
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)].[Date (ship date)]
between ?Parameter1 and ?Parameter2?
)

Hi,

What does "not filtering data as per selected date in prompt" mean? Can you explain *exactly* what you see and what you are expecting to see (bearing in mind that slicer filters are for context, and impact measure values not the members shown in sets of members on row/column edges).

MF.