WebI Purge Data #error when UserResponse and ToDate function is used in same formula

Hi,

I have a formula which works well when there is data but when I purge the webi report I get #Error for the cells wherever I have used UserResponse and ToDate function in the same formula.
Ex: =FormatDate(ToDate(UserResponse("Enter Modified Date:");"M/dd/yyyy hh:mm:ss a");"MM/dd/yyyy")

Is this known issue? If anyone knows the solution. Please answer it.

(FYI, I am using BO4.0 SP5)

Thanks.

DB Reporting ToolsSAP

Last Comment

Mike McCracken

8/22/2022 - Mon

nishant joshi

4/22/2015

Hi Naveen,

You can use IsNothing() function to check whether value exist or not.If value is not exist then assign date '1900-01-01'.

=FormatDate(ToDate((IIF(IsNothing(UserResponse("Enter Modified Date:")),'1900-01-01',UserResponse("Enter Modified Date:"));"M/dd/yyyy hh:mm:ss a");"MM/dd/yyyy"))

Open in new window

naveenreddyinus

4/22/2015

ASKER

FYI, WebI doesn't have a function called "IsNothing".

ASKER CERTIFIED SOLUTION

Mike McCracken

5/20/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options