Skip to Content

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

UserResponse Function - Options in Date Function

Hi experts,

i am trying to use the Bex query date prompts in Webi reports,

i have the prompt name as Approved date,  it is showing the correct result if i used the below mentioned formula directly

Formula Used     =UserResponse("Approved Date")

Received Output:12/29/2014 3:11:00 PM;6/1/2015 3:10:19 PM  - (expected and also correct one)

i want to do a customization of dates here,  , i am trying to get an output as 
From Date: 29/12/2014 and ToDate : 1/6/2015

Tried formula

=FormatDate(ToDate(UserResponse("Approved Date"); "MM/dd/yyyy hh:mm:ss A"); "dd/MM/yyyy") + " and " + FormatDate(ToDate(UserResponse("Approved Date"); "MM/dd/yyyy hh:mm:ss A");"dd/MM/yyyy")

i am received the output as #ERROR

i am not sure how to use the two different dates here, date values are displayed as start value and end value, i here with attached the filed details

kindly share your inputs to solve this error,

i am using BO 4.0 SP10.

Regards,

Balaji

Tags:
replied

Hi Balaji ,

Please use following formula

A=UserResponse("Approved Date")

Date1=formatdate(todate(substr([A];1;pos([A];";")-1);"MM/dd/yyyy hh:mm:ss A");"dd/MM/yyyy")
Date2= formatdate(todate(substr([A];pos([A];";")+1;length([A]);"MM/dd/yyyy hh:mm:ss A");"dd/MM/yyyy")
Let me know it will resolve your issue or not.
Regards,
Anish Mahadik
0 View this answer in context

Helpful Answer

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