Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Hello everybody,

I'm using the user response to a date prompt in a variable, but want to see it just as the date,without the time. How can I do this?

Or ,if I want to convert TIMESTAMP to a normal date format of dd/mm/yyyy in Web Intelligence, then here is the solution...


The formula works only when you have Date Prompt in your Report as shown in the above picture.

Then use the formula given below to change the Timestamp into Date format

= FormatDate(ToDate(UserResponse("Events Started After") ;""); "MM/dd/yyyy")

Then it will appear as shown in the below screen_shot..

So you can change to any format as you want.

Finally below is the list of Date and Time formats available in SAP BO Web Intelligence...

Labels in this area