Skip to Content
0
Former Member
Feb 17, 2015 at 09:09 AM

Webi Date from Bex variable display with time stamp

87 Views

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