Showing results for 
Search instead for 
Did you mean: 

creating a date range title - trying to avoid #multivalue

Former Member
0 Kudos

I have an object below  which is used in a prompt in order to only select the date and disregard the time.

The problem is in the webi report I want to use the prompted value in a title to show the date range.

THe prompt is using between e.g. dateNotTime BETWEEN startDate AND endDate

currently cant use the userResponse in a title because its a #multivalue

when I add the object "Addcalldatetime_notTime" into a vertical table in webi (where the prompt date range was startDate = 1/4/2012 and endDate = 30/4/2012) I get the list of dates but I want to use this range in a title without getting #mulitvalue is there anyway to achieve this?

object: Addcalldatetime_notTime

Convert (datetime, Convert(VARCHAR, CallDateTime, 101) , 101)

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello Dennis,

Create 2 variables to store the start dat (Var_1) and end date (var_2)

Create the new variable var_3 = "var_1" + "-" +" Var_2"

We also have the concatenate function in webi, you can use that too.