Skip to Content

Date as a range for prompts in Webi report without Start date and End date

Dec 29, 2017 at 09:21 AM


avatar image

Hi All,

I have a Webi report on Universe. There is a requirement to show the data as a prompt which should be a range.

I used between function, but this is showing the date as two separate prompts i.e, "start date" and "end date" but I have to show the date as a single prompt as a range.

I tried to apply the prompt both in Webi as well as in Unv but it is not showing as range. I also tried to create a filter in Unv with the below code in the "Where" condition: (Image attached here filter.png ) still it doesnt not work.

toDate(( Table__1."Creation Date" )) BETWEEN @Prompt('Enter Copy of Creation','D',,Mono,Free,Not_Persistent) AND @Prompt('Enter Copy of Creation Date(2)','D',,Mono,Free,Not_Persistent)

Can someone please let me know how to show date as a range without splitting the date to "Start" and "End"?


filter.png (27.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers