Skip to Content
Author's profile photo Former Member

Conversion of Timestamp into Date Format in Web Intelligence

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…

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.