Webi Date from Bex variable display with time stamp

[Former Member]

Hi, My Webi Reports(BO 4.1) are based on a BEx query. I want to display the date range the user selects, this comes from Bex variable.  User only select date range, but when displayed in the report it comes with time stamp.  The data in BW and the variable is normal date not timestamp. I use = UserResponse("Dato") It returns 01.01.2014 00:00:00;31.12.2014 00:00:00 I want to display it without the time (00:00:00). I have tried various, for example = FormatDate(ToDate(UserResponse("Dato");"");"dd.mm.yyyyy") But it returns #ERROR How can I achieve this? Regards, Reynir

[Former Member]

I would use UserResponse("Dato"; Index), this should retrieve the date without time if I remember correctly.

Best regards,

[arijit_das]

v_DateRangeSelected =UserResponse("Dato")

v_FromDateSelected =Trim(Substr([v_DateRangeSelected];1;Pos([v_DateRangeSelected];";")-1))

v_ToDateSelected =Trim(Substr([v_DateRangeSelected];Pos([v_DateRangeSelected];";")+1;Length([v_DateRangeSelected])))

v_FromDate =FormatDate(ToDate([v_FromDateSelected];"INPUT_DATE_TIME");"dd.MM.yyyy")

v_ToDate =FormatDate(ToDate([v_ToDateSelected];"INPUT_DATE_TIME");"dd.MM.yyyy")