Skip to Content
Jun 01, 2015 at 11:43 AM

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.