Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get Start Date and End Date from User Responce in Webi

Hi Experts,

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")

Former Member
Not what you were looking for? View more on this topic or Ask a question