Conversion of Timestamp into Date Format in Web Intelligence
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.