Conversion of Timestamp into Date Format in Web Intelligence

[Former Member]

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...