Please explain

building reports webintelligence
1

"From “+ If(Pos(UserResponse([D];“Enter Start Date:”);” “)=0;UserResponse([D];“Enter Start Date:”);Substr(UserResponse([D];“Enter Start Date:”);1;Pos(UserResponse([D];“Enter Start Date:”);” ")))

bodiscussion (BOB member since 2010-07-11)

2

It’s actually removing the time stamp from the user response.

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

3

Hi,

There is a prompt on Start Date in the report and as the report is run by selecting a Start Date.

The formula you posted means, if there is not space in the value selected in prompt, then return what ever is selected in the prompt, else return the same from 1st character to the position where space appears.

I think, this formula is used here to remove timestamp from the date.

You can use another formula to achieve this

=Todate(UserResponse("Date:");"")

Try that and let us know.

M H Mohammed :us: (BOB member since 2010-06-16)