How to get Start Date and End Date from User Responce in Webi
I am geting an out put of user responce(.....) in below given format
07/10/2015 12:30:43 AM;07/15/2015 12:30:43 AM
I want to display the start date and end date as below given format
Date Range : 07/10/2015 To 07/15/2015
Can anyone suggest ???
I have used the below mentioned code but it is giving me only the Start Date. How do I get the End Date aswell ?
=FormatDate(ToDate(Trim (Substr( UserResponse("Enter To Date");1;Pos(Concatenation(Trim(UserResponse("Enter To Date"));" ");" ")));"MM/dd/yyyy");"MM/dd/yyyy")