Format date in Webi

[abhimanyu_sharma]

Hi Experts,

I have a prompt "Transaction Period" in which user are giving values like - 5/1/2014 - 5/5/2014.

I need to show the end date which is 5/5/2014 as the column in the Webi Report.

I used user response function but i am getting the result like :

5/1/2014 12:00:00 Am;5/5/2014 12:00:00 Am

I need like this - 5/5/2014

[Former Member · Accepted solution]

Will you always get the user response output in the given format - 5/1/2014 12:00:00 Am; 5/5/2014 12:00:00 Am ?

Then you can use Pos() and SubStr() functions to get the end date