Skip to Content

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

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"?

Thanks.

filter.png (27.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers